GarryFreeman
New Member
- Joined
- Apr 17, 2020
- Messages
- 42
- Office Version
- 365
- Platform
- Windows
I am hoping that someone can help me with this.
In the image below you can see that I am trying to reward based on increased purchases, however this agreement is not a back to zero agreement.
In the example I am trying to reward the amount spent in a particular band between the 2 parameters. For example the difference between 95,000 and 99,999 is £4,999 which then attracts a payment of 249.95 (4,999 x 5%)
However my formula fails when the final total spend is between the bands as you can see in G24. What I need to show is £102,000 x 10%. Then M6 sums column I
If the T/O was for example £77,000 then this would attract all the cash payments in column I above row 14, add £2000 of T/O at 5% and everything below would remain blank "" with no reference to FALSE if possible
I thank you in advance for your help
Garry
In the image below you can see that I am trying to reward based on increased purchases, however this agreement is not a back to zero agreement.
In the example I am trying to reward the amount spent in a particular band between the 2 parameters. For example the difference between 95,000 and 99,999 is £4,999 which then attracts a payment of 249.95 (4,999 x 5%)
However my formula fails when the final total spend is between the bands as you can see in G24. What I need to show is £102,000 x 10%. Then M6 sums column I
If the T/O was for example £77,000 then this would attract all the cash payments in column I above row 14, add £2000 of T/O at 5% and everything below would remain blank "" with no reference to FALSE if possible
I thank you in advance for your help
Garry