3 step "if" function

A

Ash

This definitely is simple for the gurus. I have in Col K form row 3 t
100 ether "h", "p" or "k" that corresponds to the types of benefit
(choices) of employees. I want in col F to write an IF function tha
will read cells in column K Example if h then "34100-01", if k the
"34110-01" and if p then "34100-02". How do I do this? This will hel
me to make one posting (by sorting and subtotaling) entry for all tha
fall to one of these GL numbers
 
A

Ash

Nick said:
Ash

This will handle cells pre-entry (blank) also

=IF(K2="","",IF(K2="h","34100-01",IF(K2="p","34100-02","34100-03")))

and copy down

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]


"Ash" [email protected] wrote in message

This definitely is simple for the gurus. I have in Col K form row 3
to
100 ether "h", "p" or "k" that corresponds to the types of benefits
(choices) of employees. I want in col F to write an IF function that
will read cells in column K Example if h then "34100-01", if k then
"34110-01" and if p then "34100-02". How do I do this? This will help
me to make one posting (by sorting and subtotaling) entry for all
that
fall to one of these GL numbers.
Click to expand...
Thanks a lot. This really helped to understand to evaluate formulas and
understand how the nested functions work. I now will think differently
when writing formulas.
 
Top