Posted to microsoft.public.excel.misc

T. Valko

external usenet poster

Posts: 15,768

Roundup

Maybe this:

=FLOOR(A1,0.05)+0.05

Biff

"Dennis1188" wrote in message
...
How can I round up to get these results:

13.30 13.35
13.34 13.35
13.36 13.40
13.38 13.40

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
=ROUNDUP(INT(0.xxx))	Dave F	Excel Worksheet Functions	7	September 29th 06 08:28 PM
roundup by 16s	Sum Limit and marking	Excel Worksheet Functions	3	July 28th 06 03:23 PM
how to use roundup	r4319hb	Excel Discussion (Misc queries)	2	December 24th 05 01:27 PM
Trying To Roundup only if more than zero	G33kman	Excel Discussion (Misc queries)	2	November 29th 05 08:26 PM
ROUNDUP	frustratedwthis	Excel Discussion (Misc queries)	2	July 28th 05 09:03 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us