Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help on IF function
I seem to not be able to figure out the following formula. I am trying to
have the formula give back ascribed #'s per text value, if no text =0. Can anyone help. =IF(Q="Disastrous",1,(IF(Q="Unacceptable",2,(IF(Q= "Undesirable",3,(IF(Q="Neutral",4,(IF(Q="Acceptabl e",5,(IF(Q="Preferred",6))))))))))) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help on IF function
I ASSUME Q is not a named variable and hence should be a cell address:
Try (and copy down your column if required): =IF(Q1="Disastrous",1,(IF(Q1="Unacceptable",2,(IF( Q1="Undesirable",3,(IF(Q1="Neutral",4,(IF(Q1="Acce ptable",5,(IF(Q1="Preferred",6,0))))))))))) HTH "CBZ" wrote: I seem to not be able to figure out the following formula. I am trying to have the formula give back ascribed #'s per text value, if no text =0. Can anyone help. =IF(Q="Disastrous",1,(IF(Q="Unacceptable",2,(IF(Q= "Undesirable",3,(IF(Q="Neutral",4,(IF(Q="Acceptabl e",5,(IF(Q="Preferred",6))))))))))) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help on IF function
Have a look in the help index for LOOKUP.
=LOOKUP("C",{"a","b","c","d";1,2,3,4}) -- Don Guillett SalesAid Software "CBZ" wrote in message ... I seem to not be able to figure out the following formula. I am trying to have the formula give back ascribed #'s per text value, if no text =0. Can anyone help. =IF(Q="Disastrous",1,(IF(Q="Unacceptable",2,(IF(Q= "Undesirable",3,(IF(Q="Neutral",4,(IF(Q="Acceptabl e",5,(IF(Q="Preferred",6))))))))))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Datevlaue function/ day/month/year function | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |