Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use specific characters to hold value
I deal with different box sizes and I want to know how much each shipment I
make is costing in boxes. Can I use some kind of formula for a column so that if I use a specific character (ex. "3PL") Excel will automatically assign a value I've determined for that box. So, basically if Column Q has "3PL" in a cell then that cell value would be $0.73, and if it has "SPL" then $0.78 etc. This value however, needs to be applicable to formulas so that if other columns call on retrieving the info (* Column N = Column O - Column Q*) they will be able to say 'hey look, Column O is $5.00, Column Q is "3PL" which means its $0.73, so Column N = $5.00-$0.73 which is $4.27. Make sense???? Oh and I should also explain that I would like the cell to show "3PL" and not the actual value when I look at my sheet. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting characters before or after a specific character | Excel Worksheet Functions | |||
Text String - Specific Characters | Excel Worksheet Functions | |||
Replacing specific characters | Excel Discussion (Misc queries) | |||
find cells that contain specific characters | Excel Worksheet Functions | |||
Pulling out specific characters | Excel Discussion (Misc queries) |