 |
 | 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 / General Excel Questions / May 2008Rounding to integers and adding plus sign
Hi, I have 2 problems My first problem is that I have a large amount of data that I want to be rounded to the nearest integer value. What I have been using is "=INT(ROUND(Q795,2-(1+INT(LOG10(ABS(Q795))))))" to get it to 2 significant figures, and then to only take the integer value of that. It is having problems though since it will truncate numbers like 2.6 to 2 and I need them to be 3. My other problem is that I want some sort of formula to make a certain cell equal + if the number I am testing is positive... I'm not good with coding but something like If N16>0 then N15 = + also if you tell me the code can you please walk me through how to input that? Thanks a lot Okay I found a way to get around the first part of my problem since it was not needed anyway. Now all I need to know is how to make a cell equal "+" when the number in a different cell (say cell N16 is > 0. If N16 is < 0 then I want the cell to equal nothing, or if that is not possible, I want it to equal "-" Thanks for any help ~Joe > Hi, I have 2 problems > My first problem is that I have a large amount of data that I want to be [quoted text clipped - 10 lines] > also if you tell me the code can you please walk me through how to input that? > Thanks a lot Hi, Try this in N15: =If(N16>0,"+","") Is this what you need? Regards - Dave. Thanks! this is exactly what I was looking for > Hi, > Try this in N15: > =If(N16>0,"+","") > Is this what you need? > Regards - Dave. Try this format and the numbers can be operated on. Format, Number, Custom:= #,##0+;-#,##0 Regards Peter > Okay I found a way to get around the first part of my problem since it was > not needed anyway. [quoted text clipped - 18 lines] > > also if you tell me the code can you please walk me through how to input that? > > Thanks a lot |
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.