Hello,

I would like to create a formula like this

if value in cell B2 is between 1-5, B2*1
if value in cell B2 is between 6-10, B2*2 etc

Explanation: The value in cell B2 would keep changing. However if the value falls between any of my selected ranges, multiply that value with the appropriate number.

Can anyone help with this?

Thanks

Howdy. How many are in the "etc"? That will make a difference on how we set this up. Will that range change over time?