Remember Me?

 NubianNewbie Junior Member First recorded activity by ExcelBanter: Jun 2013 Posts: 1 Help with formula!

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. I see to be putting in the equation that would show it to be false if less than but it doesn't show 5% of that number.

Any help would be greatful!

 Claus Busch external usenet poster First recorded activity by ExcelBanter: Apr 2011 Posts: 3,785 Help with formula!

Hi,

Am Tue, 18 Jun 2013 20:39:00 +0100 schrieb NubianNewbie:

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. I see to be putting in the equation that would show it to be
false if less than but it doesn't show 5% of that number.

try:
=IF(E6+H6=60,E6+H6,0.05*(E6+H6))

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
 joeu2004[_2_] external usenet poster First recorded activity by ExcelBanter: Jul 2011 Posts: 829 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))

 Thread Tools Search this Thread Show Printable Version Search this Thread: Advanced Search Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On Similar Threads Thread Thread Starter Forum Replies Last Post solardirect Links and Linking in Excel 6 June 4th 12 10:47 PM PJ[_3_] Excel Worksheet Functions 2 June 2nd 10 03:45 PM [email protected] Excel Programming 1 July 20th 06 07:58 PM o0o0o0o Excel Worksheet Functions 6 November 19th 04 03:13 PM Muxer Excel Programming 2 July 24th 03 01:02 AM

All times are GMT +1. The time now is 12:36 AM. Copyright ©2004-2020 ExcelBanter.