Quote:
Originally Posted by otuatail
...I am trying to round up a value in cell E5. I tried =ROUNDUP(SUM(D3-NOW()))
But that is an error.
|
ROUNDUP() must have 2 properties! And the second one (num_digits) is not optional!
So ROUNDUP(A2) doesn't work, ROUNDUP(A2,1) does work!
Quote:
Originally Posted by Guessed
...The formula would still fail if D3 doesn't have a number value (eg, it is a string)....
|
SUM of the cell containing a string returns 0, not an error! I often use this, when I need some formula to handle any text values as zeros. I.e like SomeFormula(SUM(A2),...)
09-26-2023, 10:57 PM
Similar Threads
Rounding of dollar value
Windows 8 
Office 2016
Threaded Mode