wenchita1019
New Member
- Joined
- Jun 12, 2014
- Messages
- 11
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
CF3<CG3*0.1 or CF3<1
<ce3*0.35
<ce3
<ce3*0.35
<cg3*0.1 or="" cf<1="" (either="" one="" of="" these="" conditions)<="" strong="">
</cg3*0.1><cg3*0.1 or="" cf<1="" (either="" one="" of="" these="" conditions)<="" strong="">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 </cg3*0.1></ce3*0.35
</ce3
</ce3*0.35
(CF3<CG3*0.1 or CF3<1)
<ce3*0.35
<ce3
<ce3*0.35
<cg3*0.1 or="" cf<1="" (either="" one="" of="" these="" conditions)<="" strong=""><cg3, or="" cf<1)<cg3*0.1="" cf<1)
<cg3*0.1 or="" cf3<1)="" into="" the="" same="" formula.
All the amazing excel wizards out there, could someone please kindly help me with this?
Thank you! Thank you! Thank you!
Wenchita
</cg3*0.1></cg3,></cg3*0.1><cg3*0.1 or="" cf<1="" (either="" one="" of="" these="" conditions)<="" strong="">
</cg3*0.1><cg3*0.1 or="" cf<1="" (either="" one="" of="" these="" conditions)<="" strong=""></cg3*0.1></ce3*0.35
</ce3
</ce3*0.35
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
CF3<CG3*0.1 or CF3<1
<ce3*0.35
<ce3
<ce3*0.35
<cg3*0.1 or="" cf<1="" (either="" one="" of="" these="" conditions)<="" strong="">
</cg3*0.1><cg3*0.1 or="" cf<1="" (either="" one="" of="" these="" conditions)<="" strong="">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 </cg3*0.1></ce3*0.35
</ce3
</ce3*0.35
(CF3<CG3*0.1 or CF3<1)
<ce3*0.35
<ce3
<ce3*0.35
<cg3*0.1 or="" cf<1="" (either="" one="" of="" these="" conditions)<="" strong=""><cg3, or="" cf<1)<cg3*0.1="" cf<1)
<cg3*0.1 or="" cf3<1)="" into="" the="" same="" formula.
All the amazing excel wizards out there, could someone please kindly help me with this?
Thank you! Thank you! Thank you!

Wenchita
</cg3*0.1></cg3,></cg3*0.1><cg3*0.1 or="" cf<1="" (either="" one="" of="" these="" conditions)<="" strong="">
</cg3*0.1><cg3*0.1 or="" cf<1="" (either="" one="" of="" these="" conditions)<="" strong=""></cg3*0.1></ce3*0.35
</ce3
</ce3*0.35
Last edited: