Discussion Article

[ Home | Contents | Search | Reply | Previous | Next ]

Subject:
SHOW TRUE OR FALSE IF RANGE IS EVENLY DIVISIBLE BY CELL
Name:
Angel
Email (spam proof):
Email the originator of this post
Date:
Wednesday, April 02, 2008
Hits:
36
Discussion (Terms and Conditions):
I have a worksheet that I use daily that requires that a range of cells be equally divisible by a particular cell. This worksheet is an order form and that total units are evenly divisible by case pack. Ex. case pack is 3 and total units are 3,6,12,and 6 = 27 units which are all divisible by 3. I would like to have a function that serves as a trouble-shoot and alerts user whether order is equally divisible by case pack or not.

Sponsored by the best FTP application on the internet: