Minimum Rent

GLOWE

New Member
Hi,
I am putting together an excel spreadsheet to calculate rent. We offer subsidized rents based on income but we have a minimum rent of \$85. In some instances based on our calculations, the rent calculates at less than \$85. I can get the calculation to show minimum \$85 but can't get it to auto sum if over that amount. I have tried {=MIN(IF(C20:C22<85,85,C20:C22))} also =SUMIF(C20:C22<85,85,C20:C22) neither work.

Again, if over \$85 I need it to auto sum if under \$85 then \$85.

Hope someone can help

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
Code:
``[COLOR=#333333]IF(sum(C20:C22)<=85,85,sum(C20:C22))[/COLOR]``

So like that?

is it just: MIN(SUM(C20:C22),85)

Code:
``[COLOR=#333333]IF(sum(C20:C22)<=85,85,sum(C20:C22))[/COLOR]``

So like that?

Yes thank you, that worked. What a great forum

Replies
0
Views
191
Replies
2
Views
436
Replies
5
Views
170
Replies
1
Views
437
Replies
6
Views
188

Forum statistics

1,221,052
Messages
6,157,632
Members
451,426
Latest member
VinnyDoesntKnowExcelCode

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back