On Mar 25, 2:46*pm, Ziggy wrote:
How about something like this?

1 * * * 10000 * 6500

* * * * < 70% * * * * 70% < 99% * * * 100%
* * * * 0% * * *70% * * 10000%
1 * * * 10% * * 15% * * 18%
2 * * * 12% * * 18% * * 21%
3 * * * 14% * * 21% * * 24%
4 * * * 16% * * 24% * * 27%
5 * * * 18% * * 27% * * 30%

* * * * 650 * * * * * * 10%

* * * * ~=HLOOKUP(C1/B1,B4:D9,A1+1,TRUE)*C1

Oops, that 10000% should now be 100%. I played with the formula and
didn't change that.