Percentage calculation

[rosner]

Hello all out there,

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

 

[wavemehello]

sorry slipped, I mean,

if(a1>=50,160/100*a1,if(a1>=500,180/100*a1,if(a1>=5000,200/100*a1,0)))

 

[shippey121]

your formula would work but you would have to reverse the numbers, searching from high to low, this is because of the value was 5000 you would want it to do the last part of you formula but as the value 5000 is greater than 50 the first part of your formula would evaluate to true so would stop there. but essentially yes it would

HTH