Need a more efficient way to Calulate based on a range



This is my current formula. If the value in A1 is greater than 0 but less than or equal to 50 then the output is 50/50 x 80 = 80. As the value in A1 increases in increments of 50 the output increases in increments of 80. I would like to have a formula that has no upper boundary, or at least go to 1,000. Any help is appreciated.




How about this one?


If the value in A1 might be below zero the formula below would limit the result to not smaller than 0.


Answer the Question

You must create an account to use the forum. Create an Account or Login