Minimum Rent

[GLOWE]

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

 

[NeonRedSharpie]

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

So like that?

 

[West Man]

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

 

[GLOWE]

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

So like that?

Yes thank you, that worked. What a great forum