Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
=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! |