Hello,

I'm trying to structure thresholds with relation to an increasing unit amount. Please see attached image.

I have my increasing "value", and a connected "earn" and "level". The level is only achieved if it is the same amount or higher than the "value" amount.

I have added a "manual edited level" as the target.

Sorry for the cack handed explanation...does any one know what formula I would need to fill the red cells with the "earn" and "level" being known?

Thanks for any help.
Untitled2.png