Automatically Update Cells to equal 100%

[Danblski]

I am dealing with 13 columns with 3 throws of mixed percentages, I need a formula or vba that automatically adjusts mixed percentages to 100%

Here is format of spreadsheet. As you can see below those values equal 100% when summed.

45%
22%
33%

 

[Michael M]

Your question seems a bit vague but if say, the first 2 percentages were in A1 & A2, you could use

=1-(A1+A2)

 

[Danblski]

Your question seems a bit vague but if say, the first 2 percentages were in A1 & A2, you could use

=1-(A1+A2)

This only allowed me to see by how much the percentages were off by

 

[Michael M]

It was a stab in the dark, as your question is vary vague...maybe some sample data might help ?