# Need the result to show a minimum default amount or any number result greater.

1. ## Need the result to show a minimum default amount or any number result greater.

So sorry if I don't express this correctly or seem dense, anyway here goes.

I need to show a result from another cell into a cell but if the result is less than 65 it will show 65.
I am calculating window sizes and the result cell I need to copy is the height plus the width of the window. The result can be any where from 48 to 144 I then multiply this result by my price. However even though the actual window size can be as small as 48 the minimum we charge for is 65.

So I need my cell to show the result another the other cell but if the amount is less than 65 have it show 65 instead of the actual size.

Sorry for being so clumsy, I am 60 years old and I am having to learn new skills to keep a job.

thanx for any help

2. ## Re: Need the result to show a minimum default amount or any number result greater.

Here is a shot:
Assuming the cell to query is cell A1

The formula
=IF(A1<65,65,A1)

There are currently 1 users browsing this thread. (0 members and 1 guests)