IF Statement

[cdbearden]

Here is what I have in one cell:

=IF(H5=0, "BALANCED","NOT BALANCED")

Cell H5's value is $0.00.

Yet...it is saying Not Balanced.

Any help is appreciated.

Thanks!

[NBVC]

Maybe H5 is entered as text?

Try re-typing the 0 in H5.

If that doesn't work....select H5 and go to Data|Text to Columns and just click Finish.

[cdbearden]

Neither worked.

H5 is a formula too...the difference of two other cells.

I've tried changing H5 to text, to number, to currency(which is what I want).
I've tried difference formulas in H6:

=IF(H5=0, "BALANCED","NOT BALANCED")

=IF(H5=0.00, "BALANCED","NOT BALANCED")

Still does not work.

I also tried what you suggested: Data, Text to Column, Finish; but nothing happened.

[NBVC]

So is H5 exactly 0?

Probably not.... try =IF(ROUND(H5,0)=0, "BALANCED","NOT BALANCED")

[cdbearden]

Yes, H5 is exactly 0.

H5 is =C4+H4
where C4 is a positive number and H4 is a negative number.
C4 = $50.00
H4 = -$50.00

Where H5 = $0.00

And H6 should say Balanced

[cdbearden]

In addition, I've created 4 spreadsheets for reconciling. 2 of them work and 2 of them do not work. The ones that do not work have this problem. All 4 of them have the exact formulas.

[NBVC]

So the Round() formula didn't work?

possible to attach sheet here?

[cdbearden]

The Round did work, but why would it do this on 2 worksheets and not the other 2 I created. Same formulas and formats applied.

Thanks for you help!

[NBVC]

Somewhere along the line of where the precedent cells are, there is a precision issue... check all precedent cells to see what the exact numbers are (in the formula bar).

[cdbearden]

Thanks for the help