Thread
:
excluding cells from the formula when empty
View Single Post
#
6
Frank Kabel
Posts: n/a
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
Reply With Quote