nested what if statement

[Guest]

I am trying to solve this problem and really could use some help. Here is the
questions and the spread sheet information. If you have some helpful ideas
that would be awesome. Brian
cel b3 is the system date and time, cell g5 is the due date cell h5 is paid
(yes or blank) cell I is the status column and J is the action column.

Question is Satus column I: Use a nested form of the if function to display
"late" if B3 the (system date ) is greater than the due date and paid is not
yes. Otherwise the cell should appear blank (use 2 double quotes for blank
"")
Question Coulmn J: Usea a nested form of the if function to display
"collection" if the status is "Late" and amount due is less than or equal to
$100.00. Otherwise the cell should appear blank (use 2 double quotes for
blank).

 

[JE McGimpsey]

One way:

I5: =IF(AND($B$3>G5,H5<>"yes"),"late","")

J5: =IF(AND(I5="late",x<=100),"collection","")

where x is a reference to your amount due.