New to Excel and this forum...
Trying to create a sheet to track my time. On the far right is a cumulative column for the pay period. Right now it just adds the previous days + today. If there is no entry for several days, it repeats the last calculation.
How can I leave a blank field until a new values is entered??
On the example below, 60 is repeated until I go back to work. I would like these fields to stay blank to avoid confusion
Thanks
excel help.png
Like this??
=IF(A2="","",LOOKUP(1E+100,D$1:D1+A2))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Hi Glenn
In your solution D1 must be empty or has numerical value
Formula:
Please Login or Register to view this content.
based on solution proposed by Glenn Kennedy
Note: Supposed a cumulative ascending
Last edited by José Augusto; 11-29-2018 at 04:43 AM. Reason: Add note
Ha! You're right!!
Your version is neater, but this fixes it:
IF(A2="","",LOOKUP(1E+100,N(D$1:D1)+A2))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks