software

::Hi all, I'm looking for a little help here with sqrt in excel.

I know that sqrt function returns a decimal as an answer, but I'm
looking for something slight different. Is there a way to make the
fucntion return an integer, with a remainder?

For example,
D = Q^2 R
1 = 1 0
2 = 1 1
3 = 1 2
4 = 2 0

and so on

So let's say I give the function a 5, I'm expecting a 2 for Q and 1 for
remainder.::--
xcgames
------------------------------------------------------------------------
xcgames's Profile: www.excelforum.com/member.php...oamp;userid=32842
View this thread: www.excelforum.com/showthread...hreadid=526348
If you have a number in A1 then in B1

=INT(SQRT(A1)) and in C1

=A1-(B1^2)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=526348
Sorry that should have been.....

If you have a number in A1 then in B1

=INT(SQRT(A1)) and in C1

=A1-(B1^2)

....if you want it all in one cell

=INT(SQRT(A1))amp;quot; quot;amp;A1-INT(SQRT(A1))^2--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=526348Try

=INT(SQRT(A1))amp;quot; quot;amp;A1-(INT(SQRT(A1))^2)--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;xcgamesquot; gt;
wrote in message
...
gt;
gt; ::Hi all, I'm looking for a little help here with sqrt in
gt; excel.
gt;
gt; I know that sqrt function returns a decimal as an answer, but
gt; I'm
gt; looking for something slight different. Is there a way to make
gt; the
gt; fucntion return an integer, with a remainder?
gt;
gt; For example,
gt; D = Q^2 R
gt; 1 = 1 0
gt; 2 = 1 1
gt; 3 = 1 2
gt; 4 = 2 0
gt;
gt; and so on
gt;
gt; So let's say I give the function a 5, I'm expecting a 2 for Q
gt; and 1 for
gt; remainder.::
gt;
gt;
gt; --
gt; xcgames
gt; ------------------------------------------------------------------------
gt; xcgames's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32842
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=526348
gt;

dude i love you man, for that fast reply

thank you veryyy verrry much!--
xcgames
------------------------------------------------------------------------
xcgames's Profile: www.excelforum.com/member.php...oamp;userid=32842
View this thread: www.excelforum.com/showthread...hreadid=526348