more nested if function??:(

[star_26]

this is what im trying to do but i cant get the right formula for this?

use nested form of the If function to display "Collection" if I5 is "Late" and F5 > $100.00; "Write Off " if I5 is "Late" and f5 <= $100.00. otherwise the cell should appear blank (use double quotes for blank "")...


anybody have any idea? i've been working on this for more than 7 hrs

[oldchippy]

Hi,

Does this work for you?

=IF(AND(F5>100,I5="Late"),"Collection",IF(AND(F5<=100,I5="Late"),"Write Off",""))