Joe Shell Wrote:
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

It seems B13 and H13 are not really empty but contain text, probably a
formula blank. If you can't avoid text values in these cells, try:

=N(B13)*N(H13)


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=319158