Need a more efficient way to Calulate based on a range

0

=IF(A1<1,0,IF(A1<=50,80,IF(A1<=100,160,IF(A1<=150,240,IF(A1<=200,320,IF(A1<=250,400,IF(A1<=300,480,IF(A1<=350,560,IF(A1<=400,640)))))))))

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.

Answer
Discuss

Answers

0

How about this one?

=INT(A1/50)*80

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

=MAX(INT(A1/50)*80,0)
Discuss


Answer the Question

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