I have a cell that I place in a total amount. If that total amount is equal or greater than the cell in reference, then it will display "PAID". If it is less than the total, it will display "DUE" in a cell next to the total I typed in.
It is displaying the and working fine, however, what I need to add is if the cell Q6 is displaying "DUE" but the cell P6 doesn't have a total typed in, I want Q6 to stay null.
This is the working formula I have to display everything correctly...
=IF(OR($K$6<=0,$K$6=""),"",IF($K$6>=P3,"PAID",IF(OR($K$6<=P3,$K$6>0),"DUE","")))
I was thinking I just needed to add a line like: =IF(Q6="DUE","",) but when I try, it says I have too many arguments.
K6 is the cell it's comparing the total I need in the cell I type in.
Hope that makes sense.
Thanks for any help!
Bookmarks