200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
=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.
How about this one?
=INT(A1/50)*80If 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)