CAN THIS BE DONE???

[BELL]

Hi all,

This is my predicament.
I have 2 columns like this

2000 32

5000 32

and so on..

What i need it to do is when i enter the 32 into the cell, it will take a
diffent number (say 26) away from the 2000 and transfer the answer it into
another cell?

Any help on the matter would be great

 

[PCLIVE]

This is very vague. Can you be more specific what you need to do? Where
would 26 come from? Why would 32 refer to 2000 and not 5000? More details
would be helpful.

Regards,
Paul

 

[BELL]

2000 & 5000 are lenghts of pipe. 32 is the size of fitting that has to be
attached at 1 end of the pipe which takes 26mm of thread to attach.

Iam trying to get a relationship between the 32 and 26. So that for example
if i type 32 in, it will subtract 26 off the overall lenght of the pipe..

Thanks

 

[Sean Timmons]

I would assume you would have multiple fitting sizes. So, you would want a
table to indicate 32 in column A and 26 in column B and below the next
fitting size and mm size.

Then, in your table below,

Cell C2 would be =A2-VLOOKUP(B2,Sheet2!A:B,2,0)

Assuming Sheet2 has your fittings and mm sizes in columns A and B.

 

[David Biddulph]

If the 2000 is A2 and the 32 in B2, use the formula
=IF(B2=32,A2-26,"whatever you want the answer to be if B2 isn't 32")

 

[BELL]

Thats great David thanks for your input..
1 question though can i put the same formula in the same cell, to cover
different sizes of pipes?

Many Thanks
Bell

 

[David Biddulph]

If you have a large number of different sizes, you may prefer VLOOKUP rather
than nested IFs.

In each case, try Excel help.