# Re: if then formula

joeu2004
Guest
Posts: n/a

 24th Apr 2012
"rich123456" <(E-Mail Removed)> wrote:
> =((J48-M48)*L48)+(K48*L48)
> i need help adding this to this formula....
> "if the total is less than 0 then use the number in L48"

=IF((J48-M48+K48)*L48<0,L48,(J48-M48+K48)*L48)

I took the liberty of making some algebraic simplifications as well.

If all of the values in J48, K48, L48 and M48 are non-negative, you can
simplify the IF() expression as follows:

=IF(J48+K48<M48,L48,(J48-M48+K48)*L48)

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Steve Microsoft Excel Worksheet Functions 18 14th Sep 2009 10:22 PM Jackie Microsoft Excel Worksheet Functions 3 4th Feb 2009 02:49 PM =?Utf-8?B?am1lZw==?= Microsoft Excel Misc 2 31st Dec 2005 05:17 PM =?Utf-8?B?Ti5SLg==?= Microsoft Excel Worksheet Functions 2 23rd Jun 2005 06:14 PM Ralph Malph Windows XP General 2 9th Feb 2005 07:05 AM

Features