Thread
:
excluding cells from the formula when empty
View Single Post
#
4
Max
Posts: n/a
One guess ..
Try in say, I13 : =IF(OR(B13="",H13=""),"",B13*H13)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Joe Shell" <Joe
wrote in message
...
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