Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statement???
Alright, if I have this in a cell
2000 PK/TH/5000 EA/PK and I want to multiple the first number (2000) * (5000) to get to 10,000,000 in the cell as the answer. What is the best way to set up this if statement? The actual number may be smaller but the max would be a fpur digit number. Any help would be appreciated. -- Thomas |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statement???
=LEFT(A1,FIND(" ",A1)-1)*MID(A1,FIND("/",A1,FIND("/",A1)+1)+1,FIND("
",A1,FIND("/",A1,FIND("/",A1)+1)+1)-FIND("/",A1,FIND("/",A1)+1)-1) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "T Miller" wrote in message ... Alright, if I have this in a cell 2000 PK/TH/5000 EA/PK and I want to multiple the first number (2000) * (5000) to get to 10,000,000 in the cell as the answer. What is the best way to set up this if statement? The actual number may be smaller but the max would be a fpur digit number. Any help would be appreciated. -- Thomas |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statement???
Bob,
If there are no spaces between the any of it i.e. (2000PK/TH/5000EA/PK), where does that need to be changed in the function? -- Thomas "Bob Phillips" wrote: =LEFT(A1,FIND(" ",A1)-1)*MID(A1,FIND("/",A1,FIND("/",A1)+1)+1,FIND(" ",A1,FIND("/",A1,FIND("/",A1)+1)+1)-FIND("/",A1,FIND("/",A1)+1)-1) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "T Miller" wrote in message ... Alright, if I have this in a cell 2000 PK/TH/5000 EA/PK and I want to multiple the first number (2000) * (5000) to get to 10,000,000 in the cell as the answer. What is the best way to set up this if statement? The actual number may be smaller but the max would be a fpur digit number. Any help would be appreciated. -- Thomas |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statement???
"T Miller" wrote in message
... Alright, if I have this in a cell 2000 PK/TH/5000 EA/PK and I want to multiple the first number (2000) * (5000) to get to 10,000,000 in the cell as the answer. What is the best way to set up this if statement? The actual number may be smaller but the max would be a fpur digit number. Any help would be appreciated. Data/ Text to Columns/ Delimited/ by space & by slant character. then you can multiply the relevant elements. -- David Biddulph |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statement???
True, this can be done, but the information from the cell will be scrabled
sometimes, this is one way that I tried but it left some characters in the cells with the number. Thanks for the response. -- Thomas "David Biddulph" wrote: "T Miller" wrote in message ... Alright, if I have this in a cell 2000 PK/TH/5000 EA/PK and I want to multiple the first number (2000) * (5000) to get to 10,000,000 in the cell as the answer. What is the best way to set up this if statement? The actual number may be smaller but the max would be a fpur digit number. Any help would be appreciated. Data/ Text to Columns/ Delimited/ by space & by slant character. then you can multiply the relevant elements. -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If statement | Excel Worksheet Functions | |||
SQL concatenation statement | Excel Discussion (Misc queries) | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions |