Validation Test

**SaschaB** · 10-20-2011, 09:39 AM

HI Guys, I need a formula that validates an answer or input which needs to be a multiple of an given integer, i.e. input = multiple of 3, formula to validate the input in terms of 3, 6, 9, 12,... Any suggestions for me? Thanks a mil, -Sascha-

**arthurbr** · 10-20-2011, 09:42 AM

Hi and welcome to the board

Maybe MOD(Input,Integer)=0

**SaschaB** · 10-20-2011, 10:22 AM

Excellent - you suggestion works, I used it together with an validation to test a calculation result: =AND(MOD(D27,E28)=0,L26>=D54)
Works just as I need it to! Thanks a lot Arthur!

**SaschaB** · 10-20-2011, 10:32 AM

Hi There,
I am using the MROUND formula and it works well, but I need to force the result to the next multiple, i.e. always roundup instead of to the closest multiple. Any ideas? I have tired imbedded and sharing formulae - just a frustration

at the moment...

-Sascha-