Long greater than, less than formula

[cartayuk]

Hi All,

I need a formula to work out payments based on performance, the challenge I'm facing is that there are various scales of payemnt depantdant on the formula. and I just cannot figure it out.

So if A1 is greater than F1 but less than F2, I need it to show a bonus amount in H5. But then it needs to carry on in the same formule for the next bracket. So if A1 is greater F2 but less than F3, bonus payment would equal H6.

I was trying to upload a sample spreadsheet but it wouldn't allow me.

Any help would be greatly appreciated.

Thanks

 

[kweaver]

Re: Help with long greater than, less than formula

Have you tried a screen shot?

What happens when neither condition works?
Into what cell should the formula be placed?
Are those the only 2 conditions: F1 and F2, and F2 and F3?

 

[cartayuk]

Re: Help with long greater than, less than formula

Thanks for the reply.

I've

took a screenshot of the sheet I am working on. The performance is on the left and the bonus scaling on the right.

https://ibb.co/56W4psL

Thanks