IF Function not working
Sorry - I missed something else. Suggest you change "Q130.1<0.2" to
"and(Q130.1,Q13<0.2)".
Will
"roadkill" wrote:
Try putting double quotes around "good", "FAIR", and "POOR".
Will
"Loren" wrote:
I want cell S13 to give a certain answer depending on the value in cell Q13 -
I.E.
IF cell Q13 value is .1 or less then S13 = GOOD IF cell Q13 value is .1
to .2 then cell S13 = FAIR and if cell Q13 value is greater than .2 cell S13
= POOR. Here's the equation I have now and all cell S13 will tell me is #NAME?
=IF(Q13="","",IF(Q13<0.1,(good),IF(Q130.1<0.2,(FA IR),(POOR))))
--
Loren
|