Results 1 to 3 of 3

Thread: Min - Max functions????

  1. #1

    Question Min - Max functions????



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am not new to excel but I've never really fully understood or needed to get more in depth formulas/functions. I'm trying to create a formula to calculate our shipping costs for material at work. Our shipping cost is 8.5% of the net costs. Obviously a very easy formula of =F2*.085.

    I know how to set the Min (=MIN(F2*0.085,1000)) or Max (=max(F2*0.085,125)) but not both at the same time. Our shipping costs will never go below $125 and never exceed $1000.

    How do I make this work?

  2. #2
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,317
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Perhaps =MIN(MAX(F2*0.085,125),1000)

  3. #3

    Talking Thank You!

    Quote Originally Posted by Pecoflyer View Post
    Perhaps =MIN(MAX(F2*0.085,125),1000)
    I don't know why I didn't think about that. That works Perfectly. Thank You!

Posting Permissions

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