Distribute decimal value between 6 columns, as percentage

[Sybille]

Hello Forum,

I have an integer or a decimal value in column A. I need to distribute this value between columns B to G, as percentages.

Can you please help me with a formula if possible?

Attached is a sample of what I need.

Thank you!

[Sam Capricci]

what goes in 6+? is 6 where it ends so that 7.29 will still end in 6+ or does it keep going?

AND, how far up do your numbers go?

[Aardigspook]

Put this in B11 and drag down:

Please Login or Register  to view this content.

Then put this in C11 and drag down, then across to column F:

Please Login or Register  to view this content.

(the 0 will display as 0% - replace the 0 with "" if you would prefer a blank cell)

Then put this in G11 and drag down:

Please Login or Register  to view this content.

If you have a value greater than 6, this will give you a figure over 100% in column G (for example, 7.65 will give you 265%).

[Sybille]

Hello Guys,

I am so sorry I was caught in the XMas fiever and didn't have time to get back to you.
Sambo, 6+ is the end of all. Therefore, if my figure exceeds 6, there will be 100% in the 6+ column.
Aardigspook, your solution works except for the last column so I changed the formula to :

Please Login or Register  to view this content.

I also tried this one
Column B

Please Login or Register  to view this content.

from column C to G and it seems to work:

Please Login or Register  to view this content.

Thank you for your help. This thread is solved

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.