Nested If Function Contains Errors. Need help..

[HelpExcel1]

I am trying to do the following with a value in P7 to print text in an adjacent cell based on the value in P7.

I am trying to get the function to return as follows:
If P7 <.95 return LVL 8
If P7 <1.06, but >.95 return LVL 7
If P7 <1.20, but >1.06 return LVL 6
If P7 <2 but > 1.20 return LVL 5
If P7 >2 return LVL4

Here is what I wrote in excel:
IF(P7<0.95,"LVL8", IF(P7<1.06,"LVL7", IF(P7<1.20,"LVL6", IF(P7<2 "LVL5", "LVL4"))))

It returned an error in the function, but I cannot figure out exactly what I did wrong.

Thanks for the help.

 

[bsmill2]

Try this formula; =IF(P7<0.95,LVL8,IF(P7<1.06,LVL7,IF(P7<1.2,LVL6,IF(P7<2,LVL5,IF(P7>2,LVL4,0)))) Put it into the cell you want the results to go. I am guessing that lvl8,7,6,5,4 are cell locations? bsmill

 

[HelpExcel1]

Bsmill,

Thank you for this, but they are not cell values. I am trying to to have it say LVL8 in the cell corresponding to P7 when the value in P7 is less than .95. Any suggestions on how to do this?

 

[bsmill2]

Try this: =IF(P7<0.95,"LVL8",IF(P7<1.06,"LVL7",IF(P7<1.2,"LVL6",IF(P7<2,"LVL5",IF(P7>2,"LVL4"," "))))) bsmill

 

[Jonmo1]

You're just missing a comma after P7<2

 

[HelpExcel1]

You're just missing a comma after P7<2

Ha. Sometimes its so simple. Thank you.

 

[Jonmo1]

You're welcome.