How to use ISNONTEXT in nested IF statement

Hi!

So I have a table that reads the following for Allotments and Obligations and what is DESIRED for Remainder:


Allotments | Obligations | Remainder

$15 | $10 | $5

$15 | *blank but formula in cell* |$15

The Obligations column serves as both an input (whole number) and receives data from an iterative circular reference that I have created. I would like for the Remainder column to take the difference between Allotments and Obligations if the entries are nonzero and would like for the column to produce the allotment amount of the obligations column is "blank" (a formula exists here). The v

I have written a nested IF statement with an ISNONTEXT function but Excel will not accept it. Any suggestions would be greatly appreciated!

=IF(AND(A1<>0,B1<>0),A1-B1,IF(AND(A1<>0,ISNONTEXT(B1)="FALSE"),A1,""))

You should remove the quotes from around the FALSE value in your formula, like this:

=IF(AND(A1<>0,B1<>0),A1-B1,IF(AND(A1<>0,ISNONTEXT(B1)=FALSE),A1,""))

Hope this helps.

Pete

Try this ...

=IF(AND(A1<>0,ISNONTEXT(B1)=FALSE),A1,IF(AND(A1<>0,B1<>0),A1-B1,""))

Or:

=A1-N(B1)