Sorry if my title description is poor. I have 4 cells. D10 - D14. Between all 4 cells the maximum they can add up to (combined) is 8. The minimum is 0. I have also created a cell called Max # (I10). How can I make this happen? It's just a rule I need to help employees stay with in certain specifications. Thanks.
Try this...
Select the range D10:D14
Goto Data>Data Validation
Allow: Custom
Formula:
=AND(COUNT(D10),D10>=0,SUM(D$10:D$14)<=8)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks