|re: "Can I do =ROUND((D6*B27),2)"|
Then you did try it, right? I can't see your spreadsheet from where I'm sitting, so how was I supposed to know that?
If you tried it and it didn't work, why didn't you tell us that?
If I had simply answered "Yes, you can do it" would that have been a better answer?
As Mike has said, your formula works fine. When used as you described, the IF function that started this thread returns a blank cell, as expected.
So, since the values you posted work for both Mike and I, that tells me one thing:
At least one of your input values must not be what you think it is.
If B27 equals exactly 31.6% and D6 equals exactly 7009.05
then =ROUND((D6*B27),2) will return exactly 2214.86.
When that cell is compared to another cell containing exactly 2214.86 they will be found to be exactly equal.
Try this: Copy and Paste these formulas into some cells and let us know if any of them return FALSE.
They will compare the values in your cells against the hard coded values in the formula to see if your cells really contain what you think they do.
=(whatever cell contains your constant)=2214.86
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.