Formula

D

Dee

I have a spreasheet that contains a column for Column A is Invoice amount as
well as a column for taxes column B named GST another column C named PST. I
have a formula to calculate the taxes in B & C when an invoice amount is
entered into column A. However, when I drag the formula down the column 0.00
shows up in every cell down the column. Is there a way to hide the 0.00 and
only have values show up in column B and C when an amount is entered into
column A? Otherwise the spreadsheet looks really messy with all those 0.00.

I am using Excel 2003. Thanks in advance for any help.

Best regards,

Dee
 
G

Gary''s Student

Pick a cell and:

Format > Conditional Formatting... > Value is equal to 0
and then pick a font color that matches the background color
 

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

Similar Threads

Mail Merge Help 1
Cumulative formula for word table 0
Mail Merge Switch - Dollars to Words 0
Help With Formula for Posting 5
Autonumber field in Excel that behaves the same as Access 0
Sum of values in column A based on 0/1 of column B 2
Getting a formula to reflect added columns 10
Copy addition formula of non-consecutive horizontal cells 2

Top