#### 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

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>

</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”.</cg3*0.1>

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</cg3*0.1>

</ce3

</ce3*0.35

Last edited: