If, Round down help

[natei6]

Hey to all,

I'm needing a formula that says:

=IF(A1>4,A1/5) rounded down to the nearest whole number evenl
divisible by 5. Not sure how to do the last part.

Appreciation,

Nathan Sargean

 

[Peo Sjoblom]

Try

=IF(A1>4,FLOOR(A1/5,5),"")

or did you mean if A1 is greater than 4 round down A1 to the nearest number
divisible by 5, is
so use

=IF(A1>4,FLOOR(A1,5),"")

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[natei6]

*Try

=IF(A1>4,FLOOR(A1/5,5),"")

or did you mean if A1 is greater than 4 round down A1 to the neares
number
divisible by 5, is
so use

=IF(A1>4,FLOOR(A1,5),"")

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

Hi Peo,

I need A1/5 if A1 is greater than 4. But I need the result to b
rounded down to the nearest whole number evenly divisible by 5.

Example: If A1 has the number 9 entered, the result should be 1, or i
A1 has the number 10 in it, the result should be 2.

All the best,

Nathan Sargean

 

[Ron Rosenfeld]

I need A1/5 if A1 is greater than 4. But I need the result to be
rounded down to the nearest whole number evenly divisible by 5.

Example: If A1 has the number 9 entered, the result should be 1, or if
A1 has the number 10 in it, the result should be 2.

=if(a1>4,INT(A1/5),"undefined")

--ron

 

[natei6]

*On Fri, 2 Jul 2004 11:21:27 -0500, natei6


=if(a1>4,INT(A1/5),"undefined")

--ron *

Thankyou very much Ron

Have a great weekend

 

[Peo Sjoblom]

Got you

try

=IF(A1>4,INT(A1/5),"")

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)