E3:
=IF(((E2/7)-INT(E2/7))=0.4,ROUNDUP(E2/7,0),ROUNDDOWN(E2/7,0))

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Oskar" wrote:


Greetings Oracles of Excel;

I am stumped. I an attempting to simply round up and round down based
on a decimal.

A whole number value is placed in (E2) now in (E3) I want to: Divide
(E2) by 7, If decimal remainder is .3 or less round down, if .4 or more
round up.

Thanks in advance Sages of Excel.


John


--
Oskar
------------------------------------------------------------------------
Oskar's Profile: http://www.excelforum.com/member.php...o&userid=32745
View this thread: http://www.excelforum.com/showthread...hreadid=525775