IF(AND(NOT(ISBLANK Formula Trouble...

corilowenstein

Hello all,

I'm having trouble nesting the IF(AND(NOT(ISBLANK formula.

If the Provisional Requested Amount column is NOT Blank AND the Provisional Requested Amount is less than or equal to the Final Requested amount column, I want the cell to say approved... this is what I have.

=IF(AND(NOT(ISBLANK([Provisional Requested Amount]@row)), [Provisional Requested Amount]@row <= [Final Requested Amount]@row, "Approved"))

Thanks in advance.

James Keuning

=IF(AND(NOT(ISBLANK([Provisional Requested Amount]@row)), [Provisional Requested Amount]@row <= [Final Requested Amount]@row), "Approved"

James Keuning

=IF(AND(NOT(ISBLANK([Provisional Requested Amount]@row)), [Provisional Requested Amount]@row <= [Final Requested Amount]@row), "Approved"