Hi,
I have a few rows of 10 cells each, whose summed values add up to 100%
I am asking my colleagues to fill in the blank cells with their values so that their summed values can be less than 100% but NO more than 100%.
I would like to "block" the cells so that once they are under 100% they could not be able to write their values in the cells.
Is there any way to do that? If so, how?
Please help.
Thanks!
Lidia
Select the range, and assuming first row is A2:J2, then go to Data|Validation and select Custom from the allow menu... and enter formula:
=SUM($A2:$J2)<=100%
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
What is the goal figure that determines if the summed cells are 100%?
As NVBC says but using K2 as your maximum value
=SUM($A2:$J2)/$K2<=100%
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks