+ Reply to Thread
Results 1 to 6 of 6

minimum a fixed figure when it is lower

  1. #1
    Registered User
    Join Date
    06-22-2005
    Posts
    3

    minimum a fixed figure when it is lower

    My M/U figure is $ 45.25.

    how to minimum my M/U figure to $ 70.00 when everytime i get lower then $70.00? and i dont want any changes when i get higher figure.

    thanks
    Attached Images Attached Images

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996
    Try this:
    I53: =MIN(K53*I52,70)

    Does that do what you want?

    Ron

  3. #3
    Registered User
    Join Date
    06-22-2005
    Posts
    3
    Ron,

    theres still no changes with the function u'd gave.

    weepel

  4. #4
    Forum Contributor
    Join Date
    06-23-2004
    Location
    Houston, TX
    Posts
    571
    Try this ...

    =max(K53*I52,70)

    Regards.
    BenjieLop
    Houston, TX

  5. #5
    Registered User
    Join Date
    06-22-2005
    Posts
    3
    yes, thats exactly i want to know.. thanks benjie and ron for the reply.

  6. #6
    Forum Contributor
    Join Date
    06-23-2004
    Location
    Houston, TX
    Posts
    571
    You are welcome ... glad I can be of help.

    Regards.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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