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? |
#2
|
|||
|
|||
Hi Brad
With price in A, Quantity in B and your resulting new column as C =IF(ISNUMBER(A1),A1*B1,"") -- Regards Roger Govier "Brad N" wrote in message oups.com... 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? |
#3
|
|||
|
|||
If your data is set up like:
A B C D E F 1 ITEM Qty Base Option1 Option2 Total 2 P/N1234 17 $50.00 incl. $7.50 Then one way: F1: = B1*SUM(C1:E1) since SUM() ignores text In article .com, "Brad N" wrote: 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? |
Reply |
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) |