Min - Max functions????

prc232

New member
Joined
Nov 5, 2013
Messages
2
Reaction score
0
Points
0
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?
 
Top