PC Review


Reply
Thread Tools Rate Thread

Re: if then formula

 
 
Rich/rerat
Guest
Posts: n/a
 
      24th Apr 2012
rich123456

=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


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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 Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Simple - F9, then K9, then, P9, then U9, etc... Steve Microsoft Excel Worksheet Functions 18 14th Sep 2009 10:22 PM
If then, If then, If then..... Jackie Microsoft Excel Worksheet Functions 3 4th Feb 2009 02:49 PM
setup wrksht w/ column widths of 10 then 2 then 10 then 2 etc =?Utf-8?B?am1lZw==?= Microsoft Excel Misc 2 31st Dec 2005 05:17 PM
if greater then 99 then 1 if greater then 199 then two =?Utf-8?B?Ti5SLg==?= Microsoft Excel Worksheet Functions 2 23rd Jun 2005 06:14 PM
Need help with a log off/log on problem...can log off then log on dif. user and system will be slow loading user settings, then play start up music, then show wallpaper, then freeze. Ralph Malph Windows XP General 2 9th Feb 2005 07:05 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:25 PM.