How can I make a whole number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am calculating 2 numbers say 23.45*11.25=263.8125 I would like the answer
to be 263.81. I know I can format the cell to only show 2 decimal places, but
that is not what I need. I would like on only have the number 263.81 so if I
need to use that number to calculate some where else, it will not use the
rounded number of 263.8125, but the whole number of 263.81

Does that make since
 
Try something like this:

=ROUND(23.45*11.25,2)

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Hi

Use this formula:
=ROUND(23.45*11.25,2)
to round the result to 2 decimal places.

Hope this helps.
Andy.
 
Back
Top