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?

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?

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?

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?

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?