View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Jim is offline
external usenet poster
 
Posts: 615
Default 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.