Forum Discussion
Solved
IFS AND ELSE functions.
Hello, I am creating an invoice report sheet and am looking at using IFS AND formula(s) to update a status column based on dates provided in multiple cells. looking for help with creating a single fo...
Hello,
try this for size.=IF(COUNT(G7:I7)=0,"Invoice not generated",
IF(COUNT(G7:I7)=3,"Paid",
IF(AND(ISNUMBER(G7),COUNT(H7:I7)=0),"Generated",
IF(COUNT(G7:H7)=2,IF(TODAY()-H7>30,"E","Delivered - Pending payment")))))Adding line breaks in the formula with Alt+Enter helps keep the formula readable. Here is a screenshot of the formula at work:
Hello,
try this for size.
=IF(COUNT(G7:I7)=0,"Invoice not generated",
IF(COUNT(G7:I7)=3,"Paid",
IF(AND(ISNUMBER(G7),COUNT(H7:I7)=0),"Generated",
IF(COUNT(G7:H7)=2,IF(TODAY()-H7>30,"E","Delivered - Pending payment")))))
Adding line breaks in the formula with Alt+Enter helps keep the formula readable. Here is a screenshot of the formula at work:
This is perfect! Thank you!