Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3 step "if" function
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Incorporating Cell color fill in an "if" logical function? | Excel Worksheet Functions | |||
numerical integration | Excel Discussion (Misc queries) | |||
How do I use The "if" function | Excel Worksheet Functions | |||
Is it possible to insert a macro command in an "IF" function? | Excel Worksheet Functions | |||
Date & Time | New Users to Excel |