 |
 | 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 / Worksheet Functions / October 2006Help with negative number please
Hello, Appreciate any help please For example In O10:O1000 I have numbers such as... 56.50 100.00 -100.00 324.66 etc! In Q10 I have the number in O10 less 5% In Q11 I have =+IF(O11="","",Q10+O11/100*95) to keep a running total of the numbers in column "O" less 5% This is working fine until I come to a negative number in column "O" i.e. -100.00, when the number is negative I don't want to deduct 5%, how can I change the formula to do this please. Regards, Eamon =IF(O11<0),O11,IF(O11="","",Q10+(O11/100)*95)) Dave  SignatureBrevity is the soul of wit. > Hello, > [quoted text clipped - 16 lines] > > Eamon Dave, Thanks for your reply but am getting error in formula? Eamon > Hello, > [quoted text clipped - 16 lines] > > Eamon What error are you getting? SignatureBrevity is the soul of wit. > Dave, > [quoted text clipped - 22 lines] > > > > Eamon Dave, When I copy and past =IF(O11<0),O11,IF(O11="","",Q10+(O11/100)*95)) into Q11 I get the message the formula you typed contains an error and when I click OK "<0" the "0" is highlighted in black. Hope this helps. Eamon > What error are you getting? > [quoted text clipped - 25 lines] >> > >> > Eamon Your parentheses don't match, & the error being highlighted is that you don't have enough arguments for the first IF statement. To cure that, try =IF(O11<0,O11,IF(O11="","",Q10+(O11/100)*95)) or =IF(O11<0,O11,IF(O11="","",Q10+O11*95%)) But that may not be what you want. If you're trying to produce a cumulative total, you may want something more like =IF(O11<0,Q10+O11,IF(O11="",Q10,Q10+O11*95%)) SignatureDavid Biddulph > Dave, > [quoted text clipped - 36 lines] >>> > >>> > Eamon David, Just tried =IF(O11<0,Q10+O11,IF(O11="",Q10,Q10+O11*95%)) and works perfect many thanks. Thanks to David F as well. Your efforts are much appreciated. Thanks again. Best regards, Eamon > Your parentheses don't match, & the error being highlighted is that you > don't have enough arguments for the first IF statement. [quoted text clipped - 47 lines] >>>> > >>>> > Eamon Re the error only, it looks like the if got "closed" early. Try this: =IF(O11<0,O11,IF(O11="","",Q10+(O11/100)*95)) SignatureKevin Vaughn > Dave, > [quoted text clipped - 35 lines] > >> > > >> > Eamon Kevin, Thanks as well for your help, but have it solved with David's formula. Best regards, Eamon > Re the error only, it looks like the if got "closed" early. Try this: > [quoted text clipped - 41 lines] >> >> > >> >> > Eamon |
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.