Formula to Prevent a higher % to be entered...Help

[klutz]

Im looking for a way ( a formula) that will help to prevent entering a a percenta mpou

What formula can I use to accomplish the following, if it can be done.

If B9 is 100% all the rest of the % cell inputs would be 0%

If B9 is less 100% ,lets say 50% all the rest of the % cell inputs would be less than or equal to 50% until any sum of those cells equal to 100%
in which case if I enter 50% on B9 and 25% on D9 and 25% on F9 their total sum would be 100%.

If I try to enter a % on H9 it should not allow me to do it
because then the total sum on O9 would be more the the original amount on A9


I game myself a nosebleed thinking how to write this.

Any ideas.

[Simon Lloyd]

Klutz please refrain from crossposting without supplying the link(s) to your other posts, you already have a couple of answers here http://www.excelforum.com/excel-worksheet-functions/701865-formula-to-prevent-a-higher-to-be-entered-help.html#post2174267

[klutz]

Hey Sorry man, Wasn't aware it was not allowed. I wont do it again. :-)

[Simon Lloyd]

It's not that it's not allowed, it's the fact that you could be taking p the valuable free time people have working towards a solution that has already been supplied or trying solutions that have already been tried and failed!, so you need to provide links to the places that you have posted the same question to.

Please read the link in my signature, it explains it well :)