On Mar 25, 3:28*pm, Ziggy wrote:
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.

This leaves the A1 as a manual input.

If you're asking what I think you're asking, you're asking about a
circular reference. You want the formula to pick A1 but the formula
is dependent on the value in A1.

Or? What determines A1?