I got the Formula Blues

[cameron_kyle]

I have a rather complex if statement which I am batteling to create


This is my aim


Working from cell N3 if M3 is between 50% and 60% display “SEND REM” if M3 is between 75% and 85% display “SEND FINAL REM”. And if P3 has a “1” in it Display REM SENT



This seems way to complex for me to grasp this formula and any advice or support will be much apresiated

 

[GlennUK]

Your logic has big gaps in it ... what about M3 being below 49%, or being between 61% and 74%, or being between 86% and 99%?

 

[Richard Schollar]

Hi Cameron

Probably some variation on the following will work, however, since you appear to have 'gaps' in yopur criteria (ie what happens between 60% and 75%?) it needs work:

=IF(P3=1,"REM SENT",LOOKUP(M3,{0,0.5,0.75},{"","SEND REM","SEND FINAL REM"}))

Best regards

Richard

 

[cameron_kyle]

thank you to fella, this formula works great it really helped, thank you ]