If you are using the SUM function rather than addition operators, you will
note from Help that SUM ignores True/False values.


On Tue, 8 Feb 2005 15:05:28 -0800, "Jason Morin"
wrote:

For some reason I have to multiply my boolean values by 1
in order sum them. I haven't figured out why.

Jason

-----Original Message-----
=IF(MOD(A1,1)=0.5,A1,INT(A1)+(MOD(A1,1)=0.6)*1)

You don't actually need the *1 because the addition of
the INT and MOD
functions will convert the Boolean.

=IF(MOD(A1,1)=0.5,A1,ROUND(A1,0))

will also work

Regards

Sandy
--
to e-mail direct replace @mailinator.com with



"Jason Morin" wrote
in message
...
If you mean greater than or *equal* to .6, try:

=IF(MOD(A1,1)=0.5,A1,INT(A1)+(MOD(A1,1)=0.6)*1)

HTH
Jason
Atlanta, GA

-----Original Message-----
i would like to use the round function so that if the
1st
decimal place is .6 it rounds up and <.4 it rounds
down,
but does nothing if =.5

can this be done?
.



.