Hi!

What do you mean by: "...get ... to run when some cells are blank please" ?

If any or both cells are empty the formula will return zero.

If you mean that any or both of these cell may contain formula blanks: "",
then the formula will return an error.

If that's the case what value do you want the formula to return?

Biff

"Ted" wrote in message
...
Hi, can anyone tell me how to get:

=ROUND(D23*C42,3)

answer appears in cell E23

to run when some cells are blank please? I have other formula doing
similar
stuff, but are unsure if the principles are generic - cant get it to work
either way, so are open to suggestions??

Ted.