IF Formula question

[rnkhan]

Hi!

I have two columns that I am working with, labeled Dates and Amount. Since it contains 1,900 records, I don't want to go line by line for each and every single one of them. Here's what I'm looking for:

Date >0 | Amount >0 --> Desired Outcome: True
No Dates | Amount>0 --> Desired Outcome: False
Date >0 | Amount =0 --> Desired Outcome: False
No Dates | Amount=0 --> Desired Outcome: True

Is there a single IF formula that will cover the above criteria?

Thanks.

--rk

 

[jmthompson]

Updated to to include full request

=OR(AND(A4>0,B4>0),AND(A4=0,B4=0))

update a and b to your columns

 

[mole999]

=IF(AND(A4>0,B4>0),"True",IF(AND(A4="",B4>0),"False",IF(AND(A4>0,B4=0),"False",IF(AND(A4="",B4=0),"True","Unknown"))))