Solved: if or formula

[jaureguima]

Quick question I am trying to create a formula for the following

if a2 <= then .931 then have it state "pending"
If a2 >= 1.18 the have it state ?complete?
If it is not <=.931 or >= 1.18 then have it state ?questionable?

[lenze]

=IF(A2<=0.931,"pending",IF(A2<1.18,"questionable","complete"))


lenze

[jaureguima]

thanks I wasn't putting the double " " man that was driving me crazy lol:doh: