View Single Post
  #6   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
try
=N(B13)*N(H13)

--
Regards
Frank Kabel
Frankfurt, Germany

"Joe Shell" <Joe schrieb im
Newsbeitrag ...
i am designing a cost spreadsheet for recipes, i need to exclude

cells from a
formula when, no data is entered, then i need to include the cell

when data
is entered.
Input (b13) Input2 (h13) Result
0 0 #Value!
When i enter =sum(b13*h13) i get #Value!

If anyone understands my problem, PLEASE HELP