Showing "0.00" for formula results

K

kate_suzanne

I have a feeling that this is a simple thing...yet I have spent too much time
already trying to figure out this "simple" thing.

I have a simple purchase order document set up in Excel 2007. I have a
formula in the total cost column that essentially multiples the quantity by
the unit cost. I would like the total cost cell for each item to appear
blank (yet not remove the formula) if there is nothing entered into the cell
for that particular row; however, now, if there is no quantity or unit price
entered, the result shows as "0.00." How do I change that view...I can't get
those zeros to disappear without deleting the formula as well.

Thanks!
 
R

RagDyer

Say unit cost in Column D, and quantity in Column E, try something like
this:

=If(Or(D2="",E2=""),"",D2*E2)
 
F

FSt1

hi
try this.
=if(unitcost*quanty = 0,"",unitcost*quantity)

if the formula results in 0, the cell will appear blank but will show the
results if there is a quantity and unit cost.

Regards
FSt1
 
T

T. Valko

Try something like this....

Test the quantity cell to make sure there is in fact an entry. If no
quantity is entered leave the total cost cell blank:

=IF(COUNT(A1),A1*B1,"")
 
D

Dave Peterson

Maybe you could modify the formula:

If you have to have column A and column B in your calculations, you could use:

=if(or(a1="",b1=""),"",a1+b1)
(for instance)

(If either is blank, then show blank. Else do the add.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top