A set low number of 100 is in cell B4, and a related set high percent of 18% is in cell B6.

A set high number of 1,000 is in cell D4, and a related set low percent of 14% is in cell D6.

In cell B8 a manual number will be typed between 100 and 1,000.

In cell B10 we want a formula that will roundup a percentage number between 14% and 18% depending on the number inserted in B8.

Regards, Gary