+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Registered User
    Join Date
    01-25-2013
    Location
    Tacoma, Wa
    MS-Off Ver
    2010
    Posts
    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. #2
    Valued Forum Contributor
    Join Date
    05-08-2012
    Location
    Georgia, USA
    MS-Off Ver
    Excel 2003, 2010
    Posts
    811

    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)
    Click on star (*) below if this helps

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1