Posted to microsoft.public.excel.misc

LINDA

external usenet poster

Posts: 205

Rounding by .05

I have a formula where the cell multiplies the answer of 100/60. I put the
formula in as =A2*100/60 The answer comes out as 53.33333. I want the
answer to round up to 53.35, when I add the roundup in front of the A2 to
rounds up to 54.00,
Can someone tell me how I can make it round to the nearest .05?

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
IF take 2 (ROUNDING)	Neil Pearce	Excel Discussion (Misc queries)	3	July 20th 07 02:26 PM
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	Jeanette	Excel Worksheet Functions	2	December 6th 05 07:43 PM
Rounding	Bud	Excel Worksheet Functions	3	November 25th 05 02:33 AM
rounding	ynissel	Excel Discussion (Misc queries)	8	June 3rd 05 07:41 PM

All times are GMT +1. The time now is 10:54 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us