Help the ignorant.....

  • Thread starter Thread starter MichaelK
  • Start date Start date
M

MichaelK

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)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Scrabble Value calculation for Welsh words 0
Set chart series endpoint dynamically 0
Excel How to find the most common pairs and triplets numbers? 5
problems getting this macro to work 23
SumIf with multiple Criteria 6
Excel Concatenate with line breaks but ignore blank cells 3
summarizing data from various workbooks 3

Back
Top