Replace cell with another number

I'm sure this will be easy for someone, or perhaps it's not doable. Here's my issue (and I'm no excel expert, so be easy on me):

I have a calculation sheet created, and I simply need one cell to calculate a total based on user input information. This is working great with drop down selections and all. Now I need to do a check on the total. If the total is < 50 dollars, then we need to force the total to say 50, because that's the minimum. I'm having no luck. Anything that'll help me at this point is welcomed. Please! Thanks.

It's a very simple sheet in reality! It's a rent calculator, so the user chooses their city (dropdown) B2, number of people in house (B3), monthly income (B5), and then rental amount (B6). B7 then calculates the rent amount they'd be responsible for if they were approved for public housing. If B7's total is < 50 dollars, then I need to force B7 to say 50 since that's the minimun number anyone can pay. I hope this makes sense. Thanks again.

Change your formula in B7 like this

=MIN(50,original_formula)

dll's typing too fast: =MAX(50, original_formula)

Beauty! MAX(50, Original) worked. Fewf! Thanks oh so much!

Originally Posted by shg

dll's typing too fast: =MAX(50, original_formula)

No.....thinking too slow