rounding a calculation down to the nearest 0.5 - how?

S

Suza

need to calculate holidays based on no of weeks worked x entitlement =
ROUNDED DOWN TO NEAREST 0.5 DAY

Able to round down but can't understand the 1/2 day
 
B

Bob Phillips

=Floor(num_days,0.5)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
K

Kevin B

The following function might work for you:


=IF(MOD(A1,1)>=0.5,INT(A1)+0.5,A1)

The MOD function divides the value in a1 by 1 and returns the remainder, if
the remainder is >= .5, it adds .5 to the integer value in A1, otherwise it
returns A1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rounding to nearest 0.5 in Excel 2007 4
rounding down to nearest 1/32 3
Round time to nearest 15 minutes in decimal format 4
Rounding to the nearest cent...currency values 3
rounding to nearest 0.5 in excel 4
How to use Ceiling to round? 11
Round Down to the nearest multiple 3
rounding up to nearest specified whole number 1

Top