**Question description:**

*This user has given permission to use the problem statement for this blog.*

I need a formula to work out if a number is Â£50,000 less than budget then bonus is zero but if its Â£50,000 up on budget then bonus is 0.5%?

Solved by G. Q. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
27/06/2018 - 10:16

Hi…Welcome to Got It Pro

Excelchat Expert
27/06/2018 - 10:17

Shall I illustrate the formula in the preview sheet?

User
27/06/2018 - 10:17

Yes please

Excelchat Expert
27/06/2018 - 10:21

Looks like there must be another condition as well

User
27/06/2018 - 10:21

I don't know if thats what I'm looking for, maybe I didnt explain myself

User
27/06/2018 - 10:21

Can I put my figures in the spreadsheet and see if you can help?

Excelchat Expert
27/06/2018 - 10:21

Sure...

User
27/06/2018 - 10:23

I need a formula that will show zero if the difference is less than £50k but for every £50k over mulitply it by 0.5%?

Excelchat Expert
27/06/2018 - 10:25

oh ok..so for every 50000 you want a 0.5% increase?

User
27/06/2018 - 10:25

Yes please

Excelchat Expert
27/06/2018 - 10:26

So let's say budget is 50000, actual is 150000

User
27/06/2018 - 10:26

Ok

Excelchat Expert
27/06/2018 - 10:28

So we have difference 10000

Excelchat Expert
27/06/2018 - 10:28

sorry 100000

Excelchat Expert
27/06/2018 - 10:29

Then, Do you mean to do 50k * 0.5% and then again 50k * 0.5% to cover the 100000

Excelchat Expert
27/06/2018 - 10:32

But there is no way formula to identify how many 50k will be there in the difference, so we are lacking a logic here.

Excelchat Expert
27/06/2018 - 10:32

Is the possibility is define, say the difference can not be more than a certain number, we can do the formula.

Excelchat Expert
27/06/2018 - 10:35

Please see the formula in B7. I have divided the difference amount by 50000 to know how many 50k to do a 0.5%.

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*