question: combo of if / and/ or formula

[amk1979]

combo of if / and/ or formula

can someone help with the following formula? cant figure out what i did wrong below? Would love some help. Maybe there's a cleaner way with index/match? i want to return 150 if it's either 25 or 30 and 200 if it's 35.
thank you!!

=+IF(C27=$E$18,$E$19,OR((C27=$D$18,C27=$C$18),$C$19,0))

 

[kweaver]

Welcome to Mr. Excel:

In your illustration, isn't C27 blank and C19 is a date and C18 is blank?

Also, if you post your sample using XL2BB we won't have to type your data to try to recreate it.

 

[Zot]

Not sure what is C27, or is it D27?

What about those values which is not 25, 30 or 35?

 

[Zot]

I'm assumming something like this
=IF(C27=E18,E19,IF(C27=D18,D19,IF(C27=F18,F19,"")))

 

[amk1979]

Thank you Zo! that is amazing. i was overcomplicating with "or" and playing with "and". thank you so much!!!

 

[amk1979]

sorry - Zot!