View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Sandy Mann Sandy Mann is offline
external usenet poster
 
Posts: 2,345
Default How to determine the value?

Thank you for the info David. Santa didn't bring me an updated version of
XL this year - perhaps next year....

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
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