Set up a lookup table...

See this:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"Onyx_jh" wrote in message
...
I am trying to build an "IF" formula with a lot of parameters. e.g.
=IF(A1="CAT",12.5,IF(A1="DOG", 50.6,IF(... Just continue that
on
for most of the animals out there to see the size I'm going for. I can
get
up to about 7 entries and I get the message "The specified formula cannot
be
entered because it uses more levels of nesting than are allowed in the
current file format". I don't know if I need to split the formula some
how
or just what. If possible I do need these in the same function. Any help
or
ideas/suggestions would deeply appreciated. Thank you.