"if/and/then" statement help

[mmcane2]

Hi all,

I am currently trying to create a formula utilizing 2 columns with a third column holding the formula.

I am looking to get a column to say yes or no based off the following items: 1st column has dollar amounts, the second column has 'yes/no' answers. I am looking for a formula that would take into consideration: all "no"s from the second column (first requirement) and everything over $50 from the first column (second requirement).

Any suggestions?

Thanks!

 

[Airfix9]

=IF(AND(A1>50,B1="No"),"Yes","No")

Edit to suit.

 

[Tuelor]

Would the below do it?

=If(AND(B1="No",A1>50),true,false)

Editing the above as appropriate...

 

[Tuelor]

Typing to slow on the phone

 

[Willmonbo]

try this formula in C1 assuming data is in A1 and B1

=IF(AND(A1>50,B1="no"),"Yes","no")

 

[mmcane2]

All of those work! Thanks so much!