Forum Discussion
Time sheet How to add 30 (number to cell if the cell before has value
Time sheet How to add 30 (number to cell if the cell before has value 9:05 17:05 9:00 17:00 9:00 17:00 9:00 17:00 9:00 17:00 Should be...
=if(a1<>"",30,"")
Assuming that "the cell before" means the one to the left of the cell in which this formula appears.
Seems a strange request, however, so I'd feel more comfortable with the answer if you could explain more fully what the context is.
Assuming that "the cell before" means the one to the left of the cell in which this formula appears.
Seems a strange request, however, so I'd feel more comfortable with the answer if you could explain more fully what the context is.
Hi, I have succeed with : =SI(A1>0;"30";"")
But when there is no value, it creates an error in the calculation of Total of hours/minutes
I would like that "" do not create such error
But when there is no value, it creates an error in the calculation of Total of hours/minutes
I would like that "" do not create such error