Data manipulation help required !

[gramsey]

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

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

 

[Bob Phillips]

Use MOD

=MOD(A2,1)

--

HTH

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

 

[Tom Hayakawa]

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

 

[Gate Keeper]

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

 

[Ken Macksey]

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