Thread
:
excel spreadsheet
View Single Post
#
5
Posted to microsoft.public.excel.newusers
Sandy Mann
external usenet poster
Posts: 2,345
excel spreadsheet
Isn't that exactly what pdberger's suggestion does?
--
Regards,
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"alsmith" wrote in message
...
Hi sandy/pdberger,
I want to put the answer to a calculation into a cell, this figure will
be
between 0 and 20 and will be similar to (i.e.) 14.45. I want the cell
to
display 14 (rounded down) and display +0.45 in the cell next to it.
Another
example is if the figure is 14.55, I want the cell to display 15 ( rounded
up
) and the next cell to display minus 0.45 I allocate duties to areas
and
need to be accurate with carry overs
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann