#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DEE DEE is offline
external usenet poster
 
Posts: 250
Default Formula

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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,058
Default Formula

Pick a cell and:

Format Conditional Formatting... Value is equal to 0
and then pick a font color that matches the background color
--
Gary''s Student - gsnu200781


"Dee" wrote:

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

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,836
Default Formula

Tools Options View Zero Values (unchecked)

Regards,
Ryan---

--
RyGuy


"Gary''s Student" wrote:

Pick a cell and:

Format Conditional Formatting... Value is equal to 0
and then pick a font color that matches the background color
--
Gary''s Student - gsnu200781


"Dee" wrote:

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

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default Formula

=IF(A2="","",your_existing_formula)
--
David Biddulph

"Dee" wrote in message
...
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 08:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"