I am new here and have an important question about Excel. I am a basic user and know some stuff about Excel, but couldn't find any info on how to calculate percentages.

What I want to do precisely is following: I want to introduce different values into an Excel file and need Excel to calculate automatically a sum depending on a percentage(%) value. For example, that Excel calculates 160% on any sum between 50-499,180% on any sum between 500-4999 and 200% on any sum between 5000-unlimited! These sums will be in the same column so Excel needs to analyze the sum and automatically calculate the % or preferably even the sum & percentage on top.

Hope you get what I mean and I am gratefull for any support.

Regards to all