| 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 |
| 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 | |||
Threaded Mode
