Home |
Search |
Today's Posts |
#1
|
|||
|
|||
adding a formula in a cell but when cell = 0 cell is blank
I am trying to create an invoice so when I put qty in cell A1 and the $ value
in cell B1, cell C1 has formula =B1*A1, thats fine, but having that formula running down C2 C3 C4 etc where there is nothing entered yet, I have $0.00 appearing in each cell, My question is how can I use this formula or something simular to get same answer to show a blank cell when not used -- Thanks Mike T |
#2
|
|||
|
|||
=IF(AND(A1<"",B1<""),B1*A1,"")
-- HTH Bob Phillips "Mike T" wrote in message ... I am trying to create an invoice so when I put qty in cell A1 and the $ value in cell B1, cell C1 has formula =B1*A1, thats fine, but having that formula running down C2 C3 C4 etc where there is nothing entered yet, I have $0.00 appearing in each cell, My question is how can I use this formula or something simular to get same answer to show a blank cell when not used -- Thanks Mike T |
#3
|
|||
|
|||
One way:
=IF(AND(B10,A10),B1*A1,"") -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Mike T" wrote in message ... I am trying to create an invoice so when I put qty in cell A1 and the $ value in cell B1, cell C1 has formula =B1*A1, thats fine, but having that formula running down C2 C3 C4 etc where there is nothing entered yet, I have $0.00 appearing in each cell, My question is how can I use this formula or something simular to get same answer to show a blank cell when not used -- Thanks Mike T |
#4
|
|||
|
|||
Mike T wrote:
I am trying to create an invoice so when I put qty in cell A1 and the $ value in cell B1, cell C1 has formula =B1*A1, thats fine, but having that formula running down C2 C3 C4 etc where there is nothing entered yet, I have $0.00 appearing in each cell, My question is how can I use this formula or something simular to get same answer to show a blank cell when not used Custom format the formula cell as e.g., [=0]"";General |
#5
|
|||
|
|||
Try
=if(A1*B1=0,"",A1*B1) "Mike T" wrote: I am trying to create an invoice so when I put qty in cell A1 and the $ value in cell B1, cell C1 has formula =B1*A1, thats fine, but having that formula running down C2 C3 C4 etc where there is nothing entered yet, I have $0.00 appearing in each cell, My question is how can I use this formula or something simular to get same answer to show a blank cell when not used -- Thanks Mike T |
#6
|
|||
|
|||
Aladin -
Better to use a custom format such as #,##0.00_);(#,##0.00);; The spot between the second & third semicolons is for the zero format. If left blank, zeros are suppressed. The last semicolon is for text values. Since it, too, is blank in my example, no text values would show either Duke "Aladin Akyurek" wrote in message ... Mike T wrote: I am trying to create an invoice so when I put qty in cell A1 and the $ value in cell B1, cell C1 has formula =B1*A1, thats fine, but having that formula running down C2 C3 C4 etc where there is nothing entered yet, I have $0.00 appearing in each cell, My question is how can I use this formula or something simular to get same answer to show a blank cell when not used Custom format the formula cell as e.g., [=0]"";General |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
numbers being entered show in formula bar but not in cell? | Excel Discussion (Misc queries) | |||
need help creating formula based on cell value | Excel Discussion (Misc queries) | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
looking for a formula | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |