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,""))