Adjusting Percentage of a cell

[Willie03]

Hello,

I would like to ask someone to help me modify a file that calculates percentage so that when I move the values in certain cells it automatically adjusts them to always reflect less than 7%.

basically cell G14 should always be less than 7%...

Heres a link.

http://1drv.ms/1Jsbuzx

 

[XopieX20]

I guess I dont understand this..... What are you trying to do exactly? when you "move" the values in certain cells? You want column G to ALWAYS be below 7%?

 

[Willie03]

Yes... cell G14 in particular

 

[XopieX20]

OK, but again, what are you trying to do exactly? when you "move" the values in certain cells? Is this data changing all the time? Are you changing it? Is it connected to a pivot?

 

[Willie03]

By move I refer to change the values of those cells, this data does change all the time and I change it according to values that are sent to me by finance... this data is not connected to pivots or charts...