ROUND the result of a formula

[spence]

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))

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

 

[Niek Otten]

=ROUND(YourFormula,2)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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))
|
| 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

 

[Harlan Grove]

=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?

|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))

 

[spence]

Thank both of you so much for your solution(s). It works perfectly. Now I
just have to create a macro and run it on six thousand worksheets.