Value Error when multiplying cell with Roundup function in it

Question

Hi there

I am getting a #Value! error when I try and multiply cell D12 with J12, when D12 has got the formula =IF(H12-C12>0,ROUNDUP(+H12-C12,0),"") in it.

Hopefully it is easy to solve, but it is beyond me, I am using Excel 2010.

Thanks for your help

Mark

The long version is

column B has bar products in it.

column C has the stock holding amount in it

column D works out what amount is needed to be ordered, based on the par stock less the stock holding, but this is rounded up to a whole number

column E is the multiple of D times the number of items in a "case", ie 12 or 24 bottles of beers in a case

column H is the par stock amount

column J is the number of items in a "case".

Answer 1

Hi!

Try this:

=N(D12)*J12

Markmzz

Answer 2

Thanks Mark, that works perfectly, much appreciated indeed.

You're welcome Mark.

I'm glad to help and thanks for the feedback. It is very important.

Markmzz

Answer 3

Thanks Mark, that works perfectly, much appreciated indeed.