IF(AND) Function

Cell X28 = -3.397
Cell Z28 = 0.00
Cell AA28 should = NO

Note: Cell X28 can be positve or negative

The following formula was entered into cell AA 28:


=IF(AND(ABS(X28)>Z28, Z28>0.00),"YES","NO")

This is the way I read the formula: If the absolute value of X 28 is greater than the value in Z 28 AND Z 28 > 0.00 the answer is Yes, if not the answer is No

When I finish and hit enter, the above formula is inserted in cell AA28- No error message, etc.

Is the formula correct ?

What do I need to do so the answer appears in cell AA28?

HELP ASAP

tigeravatar:

Thansk for the help. Formatting the cell to general did the trick.