| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Whole 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Whole number from fractions
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 "Jim" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Generating (in a random order)each number once from a given number | Excel Worksheet Functions | |||
| Change number format from text to number? | New Users to Excel | |||
| How do I round up fractions to the next whole number? | Excel Worksheet Functions | |||
| vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
| Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
Linear Mode
