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

ROUND the result of a formula
 

=ROUND(YourFormula,2)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"spence" wrote in message ...
|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

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

ROUND the result of a formula
 

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.

"Harlan Grove" wrote:

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