| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF / Else Statement?
This should be simple, but I'm drawing a blank here. I four different
categories with four different values and need to populate my field (in this case, N19) based on the value for that category: IF H19="IET" then C4, or H19="BUS" then C7, or H19="DSO" then C10, or H19="BPO" then C13. Can you assist in providing an appropriate formula structure for the above? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
IF / Else Statement?
Hi,
The syntax of an IF-THEN-ELSE worksheet-function in excel is: = IF( condition , then_value, else_value ) and you can nest up to 7 of them. That is, in your case: =IF(H19="IET",C4, IF(H19="BUS",C7,IF(H19="DSO",C10,IF(H19="BPO",C13, "invalid")))) -- Regards, Sébastien <http://www.ondemandanalysis.com "Ann" wrote: This should be simple, but I'm drawing a blank here. I four different categories with four different values and need to populate my field (in this case, N19) based on the value for that category: IF H19="IET" then C4, or H19="BUS" then C7, or H19="DSO" then C10, or H19="BPO" then C13. Can you assist in providing an appropriate formula structure for the above? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
IF / Else Statement?
=if(H19 = "IET", C4, if(H19="BUS", C7, if(H19="DSO", C10, if(H19="BPO",
C13)))). -- HTH... Jim Thomlinson "Ann" wrote: This should be simple, but I'm drawing a blank here. I four different categories with four different values and need to populate my field (in this case, N19) based on the value for that category: IF H19="IET" then C4, or H19="BUS" then C7, or H19="DSO" then C10, or H19="BPO" then C13. Can you assist in providing an appropriate formula structure for the above? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
IF / Else Statement?
Sorry missed the last else...
=IF(H19 = "IET", C4, IF(H19="BUS", C7, IF(H19="DSO", C10, IF(H19="BPO","")))) -- HTH... Jim Thomlinson "Jim Thomlinson" wrote: =if(H19 = "IET", C4, if(H19="BUS", C7, if(H19="DSO", C10, if(H19="BPO", C13)))). -- HTH... Jim Thomlinson "Ann" wrote: This should be simple, but I'm drawing a blank here. I four different categories with four different values and need to populate my field (in this case, N19) based on the value for that category: IF H19="IET" then C4, or H19="BUS" then C7, or H19="DSO" then C10, or H19="BPO" then C13. Can you assist in providing an appropriate formula structure for the above? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
IF / Else Statement?
Great! Thank you both for the help.
"Jim Thomlinson" wrote: Sorry missed the last else... =IF(H19 = "IET", C4, IF(H19="BUS", C7, IF(H19="DSO", C10, IF(H19="BPO","")))) -- HTH... Jim Thomlinson "Jim Thomlinson" wrote: =if(H19 = "IET", C4, if(H19="BUS", C7, if(H19="DSO", C10, if(H19="BPO", C13)))). -- HTH... Jim Thomlinson "Ann" wrote: This should be simple, but I'm drawing a blank here. I four different categories with four different values and need to populate my field (in this case, N19) based on the value for that category: IF H19="IET" then C4, or H19="BUS" then C7, or H19="DSO" then C10, or H19="BPO" then C13. Can you assist in providing an appropriate formula structure for the above? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
| Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
Hybrid Mode
