If Then formula

[Oskar]

Greetings Oracle’s of Excel;

I am stumped. I an attempting to simply round up and round down base
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 mor
round up.

Thanks in advance Sages of Excel.


Joh

 

[Peo Sjoblom]

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

 

[Cutter]

Try something like this:

=IF(E2<>"",IF(MOD(E2,7)>3,INT(E2/7)+1,INT(E2/7)),"")

Note in your original question that you have not allowed for anythin
between .3 and .

 

[Bondi]

Hi John,

=IF(E2/7<=0.3,ROUNDDOWN(E2/7,0),ROUNDUP(E2/7,0))

Regards,
Bondi

 

[Guest]

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

HTH,

 

[Oskar]

Thanks Gary... works great