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?