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...
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
Try =SI(A1>0,30,0)
Do NOT put the 30 in quotes.
Do NOT put the 30 in quotes.