If A is changed, what is new B?

[harshat30]

Hi,

In excel, I have A as 104% and B as 96%.

This 104% is the sum of percentages from a list.

Question is:

If A is changed to 100% from 104%, what will be the new B's percentage?

please provide the formula to figure this also.

Thanks in advance!

[bebo021999]

=96%*100%/104%
=92.3%
Is it are you looking for?

[harshat30]

Yes, thanks a lot!