=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!
|