Posted to microsoft.public.excel.worksheet.functions

Frances C[_2_] Frances C[_2_] is offline

external usenet poster

Posts: 31

Round formula

I need help creating a formula, right know I have

=round(a1,2)+round(b1,2)

but I need a formula that will round to 2 digits when I add all the values
of B1:b10

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How not to round a formula	Janet	Excel Discussion (Misc queries)	9	September 6th 07 03:28 AM
Round up Formula Help	Richard	Excel Discussion (Misc queries)	3	October 1st 06 08:58 PM
How do i round up the sum of a formula	ian	Excel Discussion (Misc queries)	2	May 28th 06 04:47 AM
How do I NOT round off in a formula	Sierra_07	Excel Worksheet Functions	4	October 13th 05 01:30 AM
formula to round up?	John	Excel Worksheet Functions	2	June 13th 05 11:29 PM

All times are GMT +1. The time now is 07:08 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us