Say I have a colum with 50 rows filled in with various numbers that add up to
1000. How do I create a function that would calculate the percentace of the
value from each row of the total (B1:B50/total)?

Any help would be greatly appreciated!