Posted to microsoft.public.excel.programming

Martin Fishlock[_3_] Martin Fishlock[_3_] is offline

external usenet poster

Posts: 59

Round function

Gian:

Am I missing something or can't you just use the following formula:

=INT(A1*2+1)/2

--
HTHs Martin

"Gian" wrote:

Hi,

How can I round a number with increment of 0.5 ? For e.g. 0.1 will be equal
to 0.5, 1.1 will be equal to 1.5, 1.5 will be equal to 2.0 etc.

Thanks.

Gian

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
Round up function	shifty	Excel Discussion (Misc queries)	3	December 31st 07 11:59 AM
Round Len Function Help	[email protected]	Excel Worksheet Functions	16	August 25th 06 04:27 AM
how do i set up round function	run superman	Excel Worksheet Functions	1	October 6th 05 08:13 PM
The ROUND function	Louise	Excel Worksheet Functions	3	June 23rd 05 02:45 PM
help with round function	Scott	Excel Worksheet Functions	7	February 9th 05 07:23 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us