With
A1: (a number widgets.....eg 91)
This formula charges $125 for up to 90 widgets, then charges $55 for the remainder
In the above example, the formula returns: 11,305![]()
B1: =A1*55+70*MIN(+A1,90)
(90*125+1*55)
Is that something you can work with?
Bookmarks