Needs help please, editing or creating a formula. Thank you!!!

[wenchita1019]

Hi,

I need help with a formula that meets the following conditions.

Result as “Y” in a cell when meeting all of the following conditions.
CA3<200
CB3<230
CD3<ce3*0.35< span=""></ce3*0.35<><CE3*0.35
CF3<cg3*0.1 or="" cf3<1="" (either="" one="" of="" these="" conditions)<="" span=""></cg3*0.1><CG3*0.1 or CF<1
Otherwise, the result should be “N”.

I came up with the following...
=IF(CA3>200,”N”,IF(CB3>230,”N”,IF(CD3>CE3*0.35,”N”,”Y”)))

However, I don't know how to add the last one (CF3<cg3*0.1 or="" cf3<1<="" span=""></cg3*0.1>)

All the amazing excel wizards out there, could someone please kindly help me with this?

Thank you! Thank you! Thank you! :wink:
Wenchita

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/excel-...lease-editing-creating-formula-thank-you.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: Forum Rules).