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?
|