Help with formula!
"NubianNewbie" wrote:
I need to do a formula that would show if E6 plus H6
is greater than or equal to 60 then show 60 but if
its less than 60 to show 5% of that number.
=IF(E6+H6=60,60,(E6+H6)*5%)
But are you sure that is what you truly want?
Since 5% of 60 is 3, the result of that formula will be 0 to 3 if E6+H6<60
(assuming E6+H6=0), or 60 if E6+H6=60. That is a huge discontinuity.
I wonder if you really want one of the following:
=MIN(60,5%*(E6+H6))
or
=5%*MIN(60,E6+H6)
And just in case E6+H6 might be negative:
=MIN(60,5%*MAX(0,E6+H6))
or
=5%*MIN(60,MAX(0,E6+H6))
|