Posted to microsoft.public.excel.worksheet.functions

erika rock erika rock is offline

external usenet poster

Posts: 1

How to get rid of #Value when multiplying

I am very new to Excel and I am trying to build an invoice sheet for my employer.

Here is the scenario =F21*G21

But when I leave f21 and g21 blank I get #VALUE I need it to just be blank so I have a blank invoice.

I also have =G37*9 if G37 is blank I get #VALUE

Also my subtotal =SUM(H20:H44) if any field is blank i get #VALUE

PLEASE HELP!!

Submitted via EggHeadCafe - Software Developer Portal of Choice
REPAIRING / REINSTALLING ASP.NET
http://www.eggheadcafe.com/tutorials...nstalling.aspx

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
multiplying	wineforyou	Excel Worksheet Functions	5	November 15th 09 05:35 PM
Get rid of #VALUE, after multiplying	kbouquet	Excel Worksheet Functions	1	March 16th 08 12:24 AM
Multiplying	Dave	Excel Worksheet Functions	1	November 28th 07 09:27 AM
Multiplying	BizBroker	Excel Discussion (Misc queries)	4	February 7th 06 04:38 PM
Multiplying in a row	Daniel - Sydney	Excel Discussion (Misc queries)	3	September 27th 05 12:24 AM

All times are GMT +1. The time now is 05:29 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us