Help the ignorant.....
 

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

In C3

=IF(A1=84,X1,IF(A1=72,X2,IF(A1=60,X3,ID(A1=48,X4," "))))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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

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