Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 128

Hide $0.00

I am using Excel 2007.
I am using the following formula to calculate the total cost based on 2 cells:
The formula is in Cell "F3" and is entered as this =B3*C3

How can I keep it from displaying $0.00 when the fields are empty?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to hide a pop up	Cabri	Excel Discussion (Misc queries)	2	August 2nd 07 07:08 AM
Hide Unhide Hide again	DTTODGG	New Users to Excel	1	February 15th 06 03:22 PM
HIDE-IF???	ConfusedNHouston	Excel Discussion (Misc queries)	0	August 4th 05 06:15 PM
How can I hide #VALUE!	Mark Jackson	Excel Worksheet Functions	2	December 29th 04 06:12 PM
How do I hide a worksheet in Excel and use a password to un-hide .	Dchung	Excel Discussion (Misc queries)	3	December 2nd 04 06:24 AM

All times are GMT +1. The time now is 08:39 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us