How to verification on a calculator field

[Derm_N]

Hello All,

I do hope that someone can help me with this problem I am having...

What I am trying to do is set a "Whole Number" verification on a calculator field.....

The Calculation is on the "Number of Boxes" which is "Qty Ordered" / "Box Qty"

So what I am looking to do is set a verification on the "Number of Boxes" Field.....

Any idea's?

 

[Joe4]

Welcome to the Board!

I think the ROUNDUP function should do what you want.
Use this formula in cell C2 and copy down:

=ROUNDUP(A2/B2,0)

 

[Derm_N]

Thank you for your reply on this - would the ROUNDUP just round it up....

What I am trying to get is the that the "Number of Boxes" would give a verification error as it isn't a Whole Number....

 

[Rick Rothstein]

Using cell A1 for illustration purposes, try...

=A1<>INT(A1)

 

[Joe4]

You could do something like this:

=IF(MOD(A2/B2,1)>0,"ERROR!",A2/B2)

 

[Derm_N]

Thank you all for your reply on this....

I will try these and let you know - Very helpful site....

 

[Rick Rothstein]

You could do something like this:

=IF(MOD(A2/B2,1)>0,"ERROR!",A2/B2)

I misread the question originally so my previous "answer" does not do what the OP wanted. With your solution, though, I think it might (not sure about it how it would apply to the OP's question) needs to be modified to this...

=IF(MOD(MAX(A2,B2)/MIN(A2,B2))>0,"ERROR!",A2/B2)

since the order of division matters. One caveat... if the minimum value could be 0, then the formula would have to be modified to handle the error dividing by 0 produces.