View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default Format financial results to end in specific numbers

"osbornauto" wrote:
I have a one page spreadsheet with some financial calculations
[....] I wanted the results to end in 55 cents.


If you have =formula now, change that to =INT(formula)+0.55


----- original message -----

"osbornauto" wrote in message
...
I have a one page spreadsheet with some financial calculations filling in a
few cells as results. I'd like to have each of the cells end in a
specific
cents. So, in the results cell, if the calculation was to give the
results
of $10.56, $11.74 & $13.23 - it would actually show up as $10.55, $11.55 &
$13.55 if I wanted the results to end in 55 cents.

Any suggestions on how to have all my results end in a specific result
like
that?