Square root with a remainder

[xcgames]

::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.::

 

[daddylonglegs]

If you have a number in A1 then in B1

=INT(SQRT(A1)) and in C1

=A1-(B1^2)

 

[daddylonglegs]

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))&"+"&A1-INT(SQRT(A1))^2

 

[Chip Pearson]

Try

=INT(SQRT(A1))&"+"&A1-(INT(SQRT(A1))^2)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"xcgames" <[email protected]>
wrote in message
news:[email protected]...

 

[xcgames]

dude i love you man, for that fast reply

thank you veryyy verrry much!

 

[Aladin Akyurek]

A2: 5

B2:

=QUOTIENT(SQRT(A2),1)

C2:

=A2-B2^2

 

[Harlan Grove]

Aladin Akyurek wrote...

A2: 5

B2:

=QUOTIENT(SQRT(A2),1)

C2:

=A2-B2^2

....

QUOTIENT rather than INT seems willfully inefficient.

As for the remainder, why not

=MOD(A2,B2)

well aside from the severe limitations in MOD?