IF statements with a text return value based on range

[gggmarquez]

Hi there EXCEL Gods ! Of course any help is greatly appreciated.

I need the formula to return specific text values looking at G28 to look at P28
Out to the side I’ve provided what return text should be:

If P28 is greater G28 =”Level One”
If P28 is equal to zero = “Level two”
If P28 is equal to -1 or has a negative value and is equal to but not less than G28 = “Level 3”
If p28 is less than g28= “Level 4”

I tried to put an image in but it's looking for a URL. I am work and it won't allow me to differents sites. I hope this provides enough information

---

 

[Rick Rothstein]

I need the formula to return specific text values looking at G28 to look at P28
Out to the side I’ve provided what return text should be:

If P28 is greater G28 =”Level One”
If P28 is equal to zero = “Level two”
If P28 is equal to -1 or has a negative value and is equal to but not less than G28 = “Level 3”
If p28 is less than g28= “Level 4”

Can you explain the highlighted condition in a little more detail? I am confused by your wording "or has a negative value and is equal to but not less than G28".

Also, did you really want a mix of text numbers ("One" and "two") and digits (3 and 4) for your levels?

 

[gggmarquez]

Hi there EXCEL Gods ! Of course any help is greatly appreciated.

I need the formula to return specific text values looking at G28 to look at P28
Out to the side I’ve provided what return text should be:

If P28 is greater G28 =”Level One”
If P28 is equal to zero = “Level two”
If P28 is equal to -1 or has a negative value and is equal to but not less than G28 = “Level 3”
If p28 is less than g28= “Level 4”

I tried to put an image in but it's looking for a URL. I am work and it won't allow me to differents sites. I hope this provides enough information

---

 

[njimack]

Would have been helpful if you had provided a small sample of your data and desired results. This might be what you need...

="Level "&IF(P28>G28,"One",IF(G28=0,"Two",IF(OR(P28=-1,(AND(P28<0,P28=G28))),"Three",IF(P28<G28,"Four"))))