Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Ingoring text in a formula
I know this has to be an easy problem to overcome, but I have not had
any luck finding a solution. I have a spreadsheet listing our options and pricing to our customers. I have a column that contains the quantity and another for the list price. I would like to add a column showing the price x quantity. Many of our "options" are included in the price of the system, so the price of this option shows "included". However, I am not able to multiply the quantity number times this text. I would like it to treat this text as a 0, without having to show the number 0 (I feel "included" is more intuitive for customers). Is this possible? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I create and save a formula for text fields? | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Using the text from a cell as a range name in a formula | Excel Discussion (Misc queries) | |||
Coverting Formula to Text | Excel Discussion (Misc queries) | |||
Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) |