# Re: if then formula (CORRECTION on Earlier POST)

Rich/rerat
Guest
Posts: n/a

 24th Apr 2012
rich123456,
This a Correction of earlier posting, I did include for M48 being negative.

=IF(SUM(\$J48:\$K48,-\$M48)*\$L48<0,\$L48,SUM(\$J48:\$K48,-\$M48)*\$L48)

"if you want to include 0 to have L48 as your solution then try this":

=IF(SUM(\$J48:\$K48,-\$M48)*\$L48<=0,\$L48,SUM(\$J48:\$K48,-\$M48)*\$L48)

--
Rich/rerat
(RRR News) (message rule)
((Previous Text Snipped to Save Bandwidth When Appropriate))

"rich123456" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...

i have a formula in a cell that totals the amounts in that row.

here is the formula

=((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"

any help here would be greatly appreciated.

--
rich123456

 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