Some time ago, I was helped with the following statement. It increased in £50 increments between between the 6-10% value field
=250*((H27-E27)/E27>=5.5%)+MIN(((H27-E27)/E27>=5.5%)*INT(100*((H27-E27)/E27-5.5%))*50,200)
I need to change that vale so that rather than it increasing by £50 at every single 1% increase it now needs to increase at every 1.5% increase.
before was 6%, 7%, 8%, 9% & 10%
It now needs to be 8%, 9.5%, 11%, 12.5% & 14%
Bookmarks