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.

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.