Ken,
I'm trying it now. Can you tell me if it's possible to "copy" and paste
special the format once I have it set up in one cell?
I'm trying, but keep getting errors.
Thanks
"Ken Wright" wrote:
The VLOOKUP that has been referred to will allow you to have hundreds or
even thousands of values as in your example if you so wish. Rather more
efficient than trying to use nested IFs, and far easier to maintain as a
table of values.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"lrb" wrote in message
...
Hi Bernard,
I have many worksheets that use the same information. What I'd like to do
is assign a function so that when I type in (for example) EE-A in cell a1
that cell b1 would fill in with $295.92. This way I take the "human"
factor
out of entering figures that I could transpose or accidentally fill in the
wrong figure. My problem is that I have 12 different scenarios where cell
a1
could be EE-A or EE-B or EE-C or EE+Sp-A or EE+Sp-B or EE+Sp-C, etc etc.
Each of the 12 scenarios would need to produce their own specific dollar
amount. I know that with IF you can only assign 7 versions. Is there any
way to accomplish what I'm hoping for? It doesn't have to be an If, Then
statement. I just don't know enough about Excel to make this happen.
Thanks
for your help!
"Bernard Liengme" wrote:
Like all functions, IF allows up to 7 nesting levels. You could try a
'lookup' function (VLOOKUP, HLOOKUP)
Tell us more about the actual problem - please be concise!
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"rlb" wrote in message
...
Hello. I need help with what I thought was a simple "If, Then" type
of
function. I would like to use functions to fill information in
another
cell.
My problem is that the first cell has a possibility of 12 different
options
which would then result in a value. (So 12 options = 12 different
values.)
Is this possible or can you tell me how to accompish this task?