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

 

[wenchita1019]

Thank you, RonB1111!

I think I am getting closer. Great tip on placing ) at proper places.

The second set if IF statement is to define that if BW3 is less or equal to 2, use the first set of IF(AND(CL3... conditions starting with CL3. Otherwise, if BW3 is larger than 2, use the second set of IF(AND(CA3... conditions starting with CA3.

If non of those two sets come out TRUE, then "N".

Would that be possible?
wenchita

 

[RonB1111]

Just add a ,"N" before closing the 3rd IF, like this:

= IF(OR(CA3 = "LOI",CA3 = ""),"LOI",IF(BW3 < = 2,IF(AND(CL3 * 9 < = CK3 * 0.35,CN3 = 0,CP3 < = 230,CK3 < = 200,CS3 < = BX3 * 0.35,OR(CM3 * 9 < = CK3 * 0.1,CM3 < = 1)),"Y","N"),IF(AND(CA3 * 9 < = BZ3 * 0.35,CC3 = 0,CE3 < = 230,BZ3 < = 200,CH3 < = BY3 * 0.35,OR(CB3 * 9 < = BZ3 * 0.1,CB3 < = 1)) ,"Y",”N”)))</pre>

 

[wenchita1019]

Wow, that did the trick!!!!!

Thank you so much for your help. I truly appreciate you taking time and helping me with my puzzle.

Best.
Wenchita

 

[RonB1111]

You're welcome!