=CEILING((E1/7)-0.3,1)


--

Regards,

Peo Sjoblom


"Oskar" wrote in
message ...

Greetings Oracle's 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