Thread: =min =max
View Single Post
  #1   Report Post  
Sneibel Sneibel is offline
Junior Member
 
Posts: 1
Smile =min =max

=MIN(5,O19*0.1)

I need this to also function as a =MAX (1,O19*0.1)

I need to multiply the $ amount in O19 by 0.1 but if that number, when multiplied, is greater than $5 I need it to default to $5 and if it is less than $1 I need it to default to $1.

Any help would be much appreciated, I am extremely new to excel.

Thanks so much in advance!