How to get rid of #Value when multiplying

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
 
P

Peo Sjoblom

I assume you have another formula in F and G21 that returns a "", you can
change you multiplication formula to this instead and it should work


=IF(COUNT(F21:G21)=2,F21*G21,"")


However for the SUM formula I don't understand why you would get VALUE#
unless there is a value error in any of those cells?


SUM ignores text



--


Regards,


Peo Sjoblom
 

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

Top