Percentage cell adjustment

[The Original IronMan]

I have a grid of cells with various numbers which all represent 100%. In another single cell I have ‘100%’ typed in as a percentage. The question I have is, what formula do I need to link the grid of numbers to the single cell so that when I type in ‘80%’ in the single all the numbers in the grid change by the correct value?

 

[kweaver]

Welcome to Mr. Excel...

Would you use XL2BB to show a few examples?

 

[The Original IronMan]

Welcome to Mr. Excel...

Would you use XL2BB to show a few examples?

Hi and thanks.
I sure would

 

[Fluff]

Duplicate to: Table formulas

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.