View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
joeu2004[_2_] joeu2004[_2_] is offline
external usenet poster
 
Posts: 829
Default 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))