Divisible by given Constant

**fitzol** · 11-18-2009, 06:30 AM

I enter certain value in cell A1.
The value should be divisible by 50 ( or any other fixed value).
If so in cell B1 I need a n OK Message.
If not it should return a message in cell B1.
Please advise.

Thank you
Kart

**MickG** · 11-18-2009, 07:15 AM

Hi, Perhaps:-

Please Login or Register  to view this content.

Regards Mick

**DonkeyOte** · 11-18-2009, 07:17 AM

You could perhaps use Validation on A1 itself so as to restrict entry in the first instance ?

eg select A1 and apply the same test as a Custom validation rule of

=MOD(A1,50)=0