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
|