#VALUE

[georgyboy]

NEWBIE APPROACHING!!!!
My main aim here is to have all cells empty until text/numbers are typed in.
I am putting together an order form for a bunch of shoes. Size read from left to right (6-14) then there is a total cell, a wholesale cell (which has the wholesale dollar amount of the shoe above it)
I can get the total cell to display how many shoes are ordered and I can get the dollar amount to display too (in the WS cell)
What i am having trouble with is keeping the cells clear until info is put in them. The formula I am using in the totals cell is -
=IF(SUM(I11:O11)=0,"",SUM(I11:O11))
this leaves the totals cell empty until quantities are put into the corresponding size cells. now when i use the same formula for the WS cells,
=IF(SUM(P11:Q10)=0,"",SUM(P11:Q10))
it displays #VALUE until quantities are inputted in to the size cells.
How do i get the value# from displaying??

Sorry about the long winded description.

 

[georgyboy]

I knew it had to be something simple, or maybe i just found a work around. heres the formula i used
=IF(SUM(I11:O11)=0,"",SUM(I11:O11)*Q10)
=IF(SUM(I11:O11)=0,"",SUM(I11:O11)*R10)
they gave the values for the wholesale and retail values but left the corresponding cells clear until information had been put it into the cells


thanks for your help over the times