Proportion cells percentage

[dave_w1967]

Good Morning Guru's Wonder if anybody could help me on this matter. I have attached a small excel file to explain what Im trying to achieve,

I have two mills going normally, and have 45% of a solution going to mill1 and 20% going to Mill2, numbers are calculated and works fine.

if for some reason say mill2 stops I will then manually enter 0 and both cells 45% & 20% (65% Mill1 & Mill2 Solution) will then go to Mill1 or vice versa i.e. if mill1 is stopped then after the required cell has an input of 0 then 65% of the solution goes to mill2 and the number is calculated.

Although I have most of the calculations working I cannot seem to get the change of the percentages to work and display if I enter 0 in any one of the required cells. I',m not even close to becoming a guru so my knowledge is limited if any body could help me on this I would be extremely greatful.

Excel Document attached please feel free to amend or let me know what calculation I should be entering.

Again thanks for all your help and all the work that you do.

Best Regards.

[ChemistB]

Okay, unless there's more behind how 65% is chosen in the first place (which I'm sure there is but I'm missing it), I'd put These formulas in F25 and F26

Please Login or Register  to view this content.

[modytrane]

In F25 enter

=0.0065*C18

In F26 enter

=0.0065*C19

[modytrane]

As long as C18 and C19 add up to 100%, simple formulas in prv msg will work.

[dave_w1967]

Good Morning or Afternoon ChemistB, Thank you so much for your quick reply and your help, your formula worked perfectly, I cannot thank you enough, again your help and time is very much appreciated immensly.