IF Function not working
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 |
IF Function not working
Put quotation marks around the words good, fair, and poor. This is
because you are asking Excel to enter a text phrase in the cell. Right now Excel is looking for a named range called good, fair, and poor, and responding with #NAME because it can't find them. |
IF Function not working
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 |
IF Function not working
One way:
=IF(Q13="","",IF(Q13<=0.1,"GOOD",IF(Q13<=0.2,"FAIR ","POOR"))) In article , 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)))) |
IF Function not working
My apologies, some modification to your formula is required as well.
Please try this one: =IF(Q13<=0.1,"good",IF(AND(Q130.1,Q13<0.2),"fair" ,"poor")) |
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 |
IF Function not working
Note that simply using quotation marks won't solve the problem, as the
syntax in the third conditional is wrong (i.e., Q130.1<0.2) In article .com, "DaveO" wrote: Put quotation marks around the words good, fair, and poor. This is because you are asking Excel to enter a text phrase in the cell. Right now Excel is looking for a named range called good, fair, and poor, and responding with #NAME because it can't find them. |
IF Function not working
IF cell Q13 value is .1 or less then S13 = GOOD F cell Q13 value is .1 to .2 then cell S13 = FAIR if cell Q13 value is greater than .2 cell S13 = POOR. =IF(ISNUMBER(Q13)=FALSE,"NEXT VALUE PLS!",if(Q130.2,"POOR",IF(Q130.1,"FAIR",IF(Q13<= 0.1,"GOOD")))) regards... -- ***** birds of the same feather flock together.. "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 |
All times are GMT +1. The time now is 01:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com