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.


--
Ash

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
HIS


"Ash" 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.


--
Ash

Hi

=CHOOSE(MATCH($K3,{"h";"k";"p"},0),"34100-01", "34110-01","34100-02")


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"Ash" 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.


--
Ash

Nick Hodge Wrote:
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
HIS


"Ash" 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.


--
Ash
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.


--
Ash

Ash

Currently there are 7 levels of nested IF's allowed, if you need more than
this the usual route is to set up a table of the variables and use a VLOOKUP

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Ash" wrote in message
...

Nick Hodge Wrote:
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
HIS


"Ash" 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.


--
Ash
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.


--
Ash