ROUND the result of a formula
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<"G B"),$D$5*1.056,$D$5))
Currently the result is displaying rounded down to two decimal points but I
need the actual value to be two decimal points since it is used for other
calculations.
Thanks for any assistance.
spence
|