 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2008Answer must always be negative.
Hello all... I have a fairly straight forward formula: =sum((F29-E29)*(C29*D29)) When the resulting answer is negative I'm very happy... but when the result comes back positive, I need to make it negative... How can I go about doing this?? Thank you very much!! Shhhh =-ABS(sum((F29-E29)*(C29*D29))) > Hello all... > [quoted text clipped - 8 lines] > Thank you very much!! > Shhhh You could amend your formula to this: =-ABS(sum((F29-E29)*(C29*D29))) Hope this helps. Pete > Hello all... > [quoted text clipped - 8 lines] > Thank you very much!! > Shhhh > =sum((F29-E29)*(C29*D29)) As a side note, I don't see anything being "Summed." Did you mean Product? = -ABS(PRODUCT(C29,D29,F29-E29))  SignatureDana DeLouis > Hello all... > [quoted text clipped - 8 lines] > Thank you very much!! > Shhhh Try: =-ABS((F29-E29)*(C29*D29)) There's no need for 'SUM' in this formula Cheers Signaturemacropod [MVP - Microsoft Word] ------------------------- > Hello all... > [quoted text clipped - 8 lines] > Thank you very much!! > Shhhh
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.