Please Help, Formula Needed

[bksparkz]

Good afternoon all,
I am in need of some help. I am looking to create a formula for the following.

The folrmula is going into cell B4
if N4 = N then cell should be blank.
If N4 = Y, and if S4 is <25 days from todaydate leave cell blank ""
If N4 = Y, and if S4 Date is 25-35 (>24,<35) days from todaydate cell should say low
If N4 = Y, and if S4 Date is >34 days from todaydate cell should say High


Thank You all in advance for any help

 

[Kamolga]

=if(N4="N","",if(and(N4="Y",S4-today()<25),"",if(and(N4="Y",S4-today()>24,S4-today()<35)),"Low",if(and(N4="Y",S4-today()>34,"High",""))))

I am not sure about S4-today() though

 

[Trouttrap2]

I think this does what you want. I'm assuming you want 0-24 = blank; 25-34=low; >34=High.
=IF(N4="N","",LOOKUP(TODAY()-S4,{0;25;34;35},{" ";"low";"low";"High"}))

 

[bksparkz]

Thank You so much. That worked great. I really appreciate it. Is it possible to add one more thing? I forget to mention also that if N4 is blank then B4 is blank as well.

Thank YOu

 

[Trouttrap2]

Thank You so much. That worked great. I really appreciate it. Is it possible to add one more thing? I forget to mention also that if N4 is blank then B4 is blank as well.

Thank YOu

Just add an OR to the formula
=IF(OR(N4="N",N4=""),"",LOOKUP(TODAY()-S4,{0;25;34;35},{" ";"low";"low";"High"}))