Hello,
I am making a browser based nation simulator game for a school project, and I need some help.
nsexcelhelp.jpg
I would like to force the user to enter three numbers in range D24:D26 that will add up to either zero or 100. The green values have Data Validation forcing them to be whole numbers between 0 - 100.
I can't figure this out after extensive googling and any help would be much appreciated. I'm quite new to Excel so I might not be searching for the right terms.
Daniel
Maybe this
Select D24:D26
Data > Data Validation > Data Validation
Allow:
Custom
Formula:
=OR(AND(COUNT($D$24:$D$26)<3,SUM($D$24:$D$26)<=100,$D24>=0,$D24<=100,INT($D24)=$D24),AND(COUNT($D$24:$D$26)=3,SUM($D$24:$D$26)=100,$D24>=0,$D24<=100,INT($D24)=$D24))
Last edited by mlcb; 09-01-2013 at 06:25 PM. Reason: Simpler formula
Marcelo Branco
Formula can be shortened to:
=AND($D24>=0,$D24<=100,INT($D24)=$D24,OR(AND(COUNT($D$24:$D$26)<3,SUM($D$24:$D$26)<=100),AND(COUNT($D$24:$D$26)=3,SUM($D$24:$D$26)=100)))
Thanks for the reply.
After I applied the formula it becomes impossible to change any of the values in those 3 cells (I assume because as soon as one is changed the values no longer add up)
Any idea how I can get around this?
Delete first the previous values - 2 or 3 of them.Originally Posted by danieljksn
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks