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...