If you want to use IF, start at the higher number and work down
=if(a1=84,"a",if(a1=72,"b",etc
but lookup would be better. Look in HELP index for vlookup or lookup

--
Don Guillett
SalesAid Software

"MichaelK" wrote in message
om...
Let me try to explain what I'm trying to do...

Lets says cell C3 will be "value A" if A1=84, "value B" if A1=72
"value c" if A1=60 or "value d" if A1=48. Values A,B,C or D would be
pulled from a different worksheet cell where a different formula has
already been done. This seems like it should be simple, but I can't
figure out how to do it....

Thanks in advance....

Michael