IF AND/OR statement

[onebluekey]

Hi,

I need help in combining these two statements into one with an OR. I am confused as to how to nest the two together in the appropriate sequence.

=IF(AND(G2=city,R2<5000), .15, .06)

=IF(AND(G2=state,R2<5000), .10, .04)

Thank you for any assistance on this!


Lynn

 

[Scott Huish]

If G2 doesn't match City or State, what should the return value be?

 

[Nogslaw]

You have different results for each criteria ... so I don't think you want an OR, I think you want nested IFs.

=IF(G2=city, IF(R2<5000, .15, .06), IF(G2=state, IF(R2<5000, .10, .04), "YOU NEED SOMETHING HERE IF G2 <> CITY OR STATE"))

If I am misunderstanding something, please try a better explanation.

 

[onebluekey]

Thank you both for a quick reply!


@Nogslaw - you got it right! I didn't know what is needed to get the result. The nested IFs is the right one to use!

Thank you for your help!


Lynn

 

[Nogslaw]

Thanks onebluekey ... but don't count HOTPEPPER out of this just yet ... there is a reason he has 14,000+ posts! He may have a more efficient solution for your problem than the nested IFs.