ROUND the result of a formula
"Niek Otten" wrote...
=ROUND(YourFormula,2)
In this case, when B12 is blank, the OP's original formula would return "",
and wrapping that inside ROUND would return #VALUE! That's a good idea?
"spence" wrote...
|I have the following formula and need the result to round to two decimal
|points:
|
|=IF(ISBLANK(B12),"",IF(AND(D12=IFIS!$C$2,$F$3< "GB"),$D$5*1.056,$D$5))
....
=IF(ISBLANK(B12),"",
ROUND(IF(AND(D12=IFIS!$C$2,$F$3<"GB"),$D$5*1.056 ,$D$5),2))
|