Thread: If Then formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Oskar
 
Posts: n/a
Default If Then formula


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