If statements

Jared Pietila

I am trying to generate a 1, 2, or 3 depending on if certain cells have text in them. So far I have

=IF([Invoice Number]@row = " ", "1" , "2"), IF([Paid Date]@row = "<>", "3" ,"2")

What I need is

if invoice number is empty a 1.

if invoice number is full and paid date is empty a 2.

if invoice number is full and paid date is full a 3.

Antonio Figueroa

I would use a nested if statement with an "AND"

Please try the formula below

=IF([Invoice Number]@row < 1, 1, IF(AND([Invoice Number]@row > 1, [Paid Date]@row > 1), 3, 2))