 |
 | 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 / September 2007how to add ( and ) when using function sum
want to add 1+2+3 = (6) how do to it? =SUM(1,2,3)  SignatureRegards, Peo Sjoblom > want to add 1+2+3 = (6) > > how do to it? =sum(1,2,3) SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > want to add 1+2+3 = (6) > > how do to it? guess I did not pose the correct question I want the end result to be in brackets =sum(xxxx) =(total) > =sum(1,2,3) > >> want to add 1+2+3 = (6) >> >> how do to it? No you didn't, use custom formats like (General) or (0.00) SignatureRegards, Peo Sjoblom > guess I did not pose the correct question > [quoted text clipped - 7 lines] >>> >>> how do to it? thanks it works > No you didn't, use custom formats like > [quoted text clipped - 15 lines] >>>> >>>> how do to it? Hi Sulasno, A few different ways, In cell A1 type =1+2+3 and enter or Put 1 in A1, 2 in A2, 3 in A3, Then in A4 put =A1+A2+A3 Then in A5 put =SUM(A1:A3) That's three ways of achieving the same outcome. The thing with Excel is there is no hard and fast rule that says one particular way is the best way. There are many ways to achieve what you are trying to do and the only criteria for the best way is what suits what you are trying to achieve at the time. HTH Martin > want to add 1+2+3 = (6) > > how do to it? >want to add 1+2+3 = (6) > >how do to it? Custom Format your cell Format/Cells/Number/Custom Type: (General) You should be aware that there is a convention that considers numbers enclosed in parentheses as being negative numbers --ron |
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.