 |
 | 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 2006Whole number from fractions
Hello, I can use help with a formula. I am trying to reach a whole number result. Example: 75 x 10% = 7.5 .. however I need the result to calculate to the closest whole number, in this case 8. Now I know I change the formatting however I need to take the 8 and times it by a dollar amount, so the result needs to be accurate. Thanks in advance for the help. To round to the nearest integer, use the ROUND() function, as: =ROUND(75 * .10,0) will return 8 =ROUND(74 * .10,0) will return 7 > Hello, I can use help with a formula. I am trying to reach a whole number > result. Example: 75 x 10% = 7.5 .. however I need the result to calculate > to the closest whole number, in this case 8. Now I know I change the > formatting however I need to take the 8 and times it by a dollar amount, so > the result needs to be accurate. Thanks in advance for the help. |
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.