Thread: IF Statement???
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T Miller T Miller is offline
external usenet poster
 
Posts: 15
Default 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