calculation method

[Zalabya83]

hello, i would like to know if there’s an equation to help me automatically calculate/multiply any extra 1 percent after 100% with 1.5 as factor for the extra 1 percent

 

[Joe4]

Probably, but I think we need more details. 100% percent of what?
It may help us understand what you are working with a little better if you can provide us with an actual example.

 

[Zalabya83]

sorry for the lack of info, let’s say we have in retail sales department the employees got 100% of their achievements and we want to calculate any extra 1 percent with 1.5 as an example to give them incentive for the extra achievement, i hope this clarifies things

 

[Joe4]

If you have 105% in cell A1, and wanted to give them 1.5 times the amount over 100% (so it should be 107.5%), then use this formula:

=IF(A1>100%,100%+(A1-100%)*1.5,A1)

 

[Zalabya83]

thank u so much dear

 

[Joe4]

You are welcome.