Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|