| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CAN THIS BE DONE???
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CAN THIS BE DONE???
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" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CAN THIS BE DONE???
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 "PCLIVE" wrote: 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" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CAN THIS BE DONE???
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. "BELL" wrote: 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 "PCLIVE" wrote: 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" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CAN THIS BE DONE???
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") -- David Biddulph "BELL" wrote in message ... 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 "PCLIVE" wrote: 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" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CAN THIS BE DONE???
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" wrote: 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") -- David Biddulph "BELL" wrote in message ... 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 "PCLIVE" wrote: 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" wrote in message ... 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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CAN THIS BE DONE???
If you have a large number of different sizes, you may prefer VLOOKUP rather
than nested IFs. In each case, try Excel help. -- David Biddulph "BELL" wrote in message ... 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" wrote: 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") -- David Biddulph "BELL" wrote in message ... 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 "PCLIVE" wrote: 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" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
