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