| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested if
I have 4 "if" scenarios for which I am looking a formula. It is just a basic scenario where I have 4 choices and I need this formula to read the four options correctly. Kind of if a then 1, if b then 2,,, Thanks for your help. Merry Christmas and Happy Holidays for all. -- ab3d4u |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nested if
Lots of ways, depending on your actual needs. One:
=IF(A1="a", 1, IF(A1="b", 2, IF(A1="c", 3, 4))) Another: =MATCH(A1,{"a","b","c","d"}) In article , ab3d4u wrote: I have 4 "if" scenarios for which I am looking a formula. It is just a basic scenario where I have 4 choices and I need this formula to read the four options correctly. Kind of if a then 1, if b then 2,,, Thanks for your help. Merry Christmas and Happy Holidays for all. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nested if
=IF(A1=B1,1,if(B1=C1,2,if(C1=D1,3,if(D1=E1,4,5))))
Dave On Dec 19, 12:29 pm, ab3d4u wrote: I have 4 "if" scenarios for which I am looking a formula. It is just a basic scenario where I have 4 choices and I need this formula to read the four options correctly. Kind of if a then 1, if b then 2,,, Thanks for your help. Merry Christmas and Happy Holidays for all. -- ab3d4u |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nested if
Here is an example of a nested IF:
=IF(A1="A",1,IF(A1="B",2,IF(A1="C",3,IF(A1="D",4,0 )))) Laura "ab3d4u" wrote in message ... I have 4 "if" scenarios for which I am looking a formula. It is just a basic scenario where I have 4 choices and I need this formula to read the four options correctly. Kind of if a then 1, if b then 2,,, Thanks for your help. Merry Christmas and Happy Holidays for all. -- ab3d4u |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nested if
=CODE(LOWER(A1))-96
"ab3d4u" wrote: I have 4 "if" scenarios for which I am looking a formula. It is just a basic scenario where I have 4 choices and I need this formula to read the four options correctly. Kind of if a then 1, if b then 2,,, Thanks for your help. Merry Christmas and Happy Holidays for all. -- ab3d4u |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nested if
Another way..........
=LOOKUP(A1,{0,"a","b","c","d",""},{"",1,2,3,4,""}) Vaya con Dios, Chuck, CABGx3 "ab3d4u" wrote: I have 4 "if" scenarios for which I am looking a formula. It is just a basic scenario where I have 4 choices and I need this formula to read the four options correctly. Kind of if a then 1, if b then 2,,, Thanks for your help. Merry Christmas and Happy Holidays for all. -- ab3d4u |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested IFs | Excel Worksheet Functions | |||
| nested if | Excel Worksheet Functions | |||
| Nested IF | Excel Worksheet Functions | |||
| nested if based on nested if in seperate sheet. how? | Excel Worksheet Functions | |||
| Nested Ifs | Excel Worksheet Functions | |||
![ab3d4u[_25_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
