Posted to microsoft.public.excel.worksheet.functions

EDB

external usenet poster

Posts: 1

ROUNDING

I have a formula e62/c62 - the answer is formatted for %. It is 49.48% when
carried out 2 dec. When carried out 1 is rounds to 49.5%, BUT when I have no
dec. it won't round to 50% - it stays at 49%. I can make it round to 50%,
but how come just formatting it doesn't carry through the standard rounding
up. - Thanks

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
Rounding	Esradekan	Excel Worksheet Functions	5	October 31st 07 09:47 AM
I need a formula with rounding up & rounding down to the nearest .	Tony Kay	Excel Worksheet Functions	3	May 29th 07 11:13 PM
Rounding	Steve[_2_]	Excel Worksheet Functions	3	February 28th 07 11:53 PM
rounding.	Rodney	New Users to Excel	6	September 26th 05 10:49 AM
Rounding	Ola Sigurdh	Excel Discussion (Misc queries)	0	September 22nd 05 07:56 PM

All times are GMT +1. The time now is 12:53 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us