Hi,
I would like please a formula to calculate the payment of 150 for each hour in the attached cell C12, with a minimum payment of 450.
In the attached sheet example, I expect the formula to return 882.
5.88 X 150 = 882
882 is higher than the minimum 450,
So, the final result should be 882 instead of the 21168 the present formula result I tried and did not work in E12.
Bookmarks