How can I make a whole number

[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

 

[Guest]

=ROUND(A1,2)

 

[Guest]

Try something like this:

=ROUND(23.45*11.25,2)

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

XL2002, WinXP

 

[Guest]

=ROUND(A1,2)

Please post to one group only.

 

[Guest]

Hi

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

Hope this helps.
Andy.

 

[Guest]

My apologies ... I was flicking between groups so thought you had postd to
another NG

 

[Guest]

Thank you the Round worked GREAT!!!!!

=ROUND(A1,2)