How to determine the value?

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

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
 
David,

Wouldn't that have to be:

=INT(SQRT(A1))-(ISEVEN(INT(SQRT(A1))))

(not that I have the ISEVEN() function to check it)

--
Regards,

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
It just dawned on me - I assume that ISEVEN() works on the integer part os a
number only?

--
Regards,

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk


David Biddulph said:
Yes, if non-integer it will truncate.
--
David Biddulph

Sandy Mann said:
It just dawned on me - I assume that ISEVEN() works on the integer part
os a number only?
Click to expand...
Sandy Mann said:
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

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
Click to expand...
Click to expand...
Click to expand...
 
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?
Click to expand...

=2*int((sqrt(A1)-1)/2) + 1

2*INT((x-1)/2) is the next lower even number of x. Adding 1 is the
next lower odd number.
 
Clarification....

2*INT((x-1)/2) is the next lower even number of x.  Adding 1 is the
next lower odd number.
Click to expand...

Referring to the integer part, if x is not an integer.
 
Back
Top