Hi Mike, I need zeros to be recognised in other formula, so are restricted
with the 'zero values' function.

I have added this formula and it seems to be doing the job:

=IF(N(D24)=0,"",ROUND(D24*C$48,3))

If you notice any issues with the above, then let me know please?

Thanks,
Ted.

"Mike G" wrote:

Well Jerry was right, my question was probing for what the expected inputs
are and what the expected results are. i.e. your example for num_digits = 3
meaning you want the answer rounded to 3 places. So if d23=2 and c42=10
then e23=20. Did you want 3 digit results allways?, if so format e23 for
number with 3 digit rounding and then the result = 20.000. If any one of
the multipliers causes the result to be 3 decimal places then the original
formula (,3) would round to three places. If you do not want a "0" showing
in case d23 or c42 has a "0" value, can you live with TOOLS/OPTIONS and
unchecking "zero values". There are many ways to do the task, but the hard
part is guessing what the expected results are with the given inputs. So,
if you can do that, perhaps we can give you a solution. Mike

"Ted" wrote in message
...
any suggestions Mike?

"Mike G" wrote:

whats in D23 and C42?

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

=ROUND(D23*C$42,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.