I am wanting to carry out a calculation on only one part of a particular
result in a calculation made in a spreadsheet

ie if i have the result of "2.57945" how do i get excel to then only
select the digits after the decimal point for further calculations ie
".57945" bearing in mind the whole number will not always be a fixed
value.


--
gramsey
------------------------------------------------------------------------
gramsey's Profile: http://www.excelforum.com/member.php...o&userid=16143
View this thread: http://www.excelforum.com/showthread...hreadid=275773

Use MOD

=MOD(A2,1)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"gramsey" wrote in message
...

I am wanting to carry out a calculation on only one part of a particular
result in a calculation made in a spreadsheet

ie if i have the result of "2.57945" how do i get excel to then only
select the digits after the decimal point for further calculations ie
".57945" bearing in mind the whole number will not always be a fixed
value.


--
gramsey
------------------------------------------------------------------------
gramsey's Profile:
http://www.excelforum.com/member.php...o&userid=16143
View this thread: http://www.excelforum.com/showthread...hreadid=275773

Here's one way:

Assume the number 2.45678 is in cell A1.
In cell B1 you would put: =A1-INT(A1)

Good luck,

Tom Hayakawa

"gramsey" wrote:


I am wanting to carry out a calculation on only one part of a particular
result in a calculation made in a spreadsheet

ie if i have the result of "2.57945" how do i get excel to then only
select the digits after the decimal point for further calculations ie
".57945" bearing in mind the whole number will not always be a fixed
value.


--
gramsey
------------------------------------------------------------------------
gramsey's Profile: http://www.excelforum.com/member.php...o&userid=16143
View this thread: http://www.excelforum.com/showthread...hreadid=275773

gramsey wrote in news:gramsey.1f9ne0
@excelforum-nospam.com:


I am wanting to carry out a calculation on only one part of a particular
result in a calculation made in a spreadsheet

ie if i have the result of "2.57945" how do i get excel to then only
select the digits after the decimal point for further calculations ie
".57945" bearing in mind the whole number will not always be a fixed
value.



Assuming your value is in cell A1:

First, subtract the whole number portion by using the formula =a1-int(a1).
Then perform your calculation on the result (the fractional portion).

If a1=2.57945
int(a1)=2
a1-int(a1)=.57945

Hi

assuming the data is in cell c3, you could do something like

=MOD(C3,1)

And then do what you want with it like multiply it by 1000 etc

=(MOD(c3,1)) * 1000

HTH

Ken