How to determine the value?
Yes, if non-integer it will truncate.
--
David Biddulph
"Sandy Mann" wrote in message
...
It just dawned on me - I assume that ISEVEN() works on the integer part os
a number only?
"Sandy Mann" wrote in message
...
David,
Wouldn't that have to be:
=INT(SQRT(A1))-(ISEVEN(INT(SQRT(A1))))
(not that I have the ISEVEN() function to check it)
"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
=INT(SQRT(A1))-ISEVEN(SQRT(A1))
--
David Biddulph
"Eric" wrote in message
...
There is a given value 68 in cell A1, I would like to determine the
value
based on following conditions.
Sqrt(68) = 8.24621, and the rounddown to the closest odd number, which
is 7,
and return this value in cell B1.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric
|