E
erika rock
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/tutorial...717-9f4b623c162f/repairing--reinstalling.aspx
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/tutorial...717-9f4b623c162f/repairing--reinstalling.aspx