0
OK, I figured it out on my own:
=mod(,1)
There is no function that does it directly, so you need a combination of functions. You need to remove the whole number part. The best way is doing it this way, which also works for negative numbers. Assume your value is in A2:
=ABS(A2)-INT(ABS(A2))
What else can I help you with?
Which Excel function calculates the principal portion of a loan payment?
The PPMT function.
Which function returns one value when a condition is met and returns another value when it is not met in Excel?
The IF function. See the related question below.
What is a named operation that returns a value in the Excel program used to simplify formulas?
A function.
How does the trig function ACOS work in Excel?
In Excel, the ACos function returns the arccosine (in radians) of a number.The syntax for the ACos function is:ACos( number )number is a number between -1 and 1. It is the cosine of the angle that you wish to find.Applies To:Excel 2007, Excel 2003, Excel XP, Excel 2000
Can you use the PMT function in Excel to display dates in many different formats?
The PMT function returns the payment amount for a loan, so it has nothing to do with how dates are displayed. It returns numbers.
What function searches for a specific value in a table and returns that value's relative position from the table not the value itself in Excel?
The MATCH function can do that.
What excel function searches for a specific value in a table and returns that value's relative position from the table not the value itself?
The MATCH function.
What is NPER in Excel?
NPER is a financial function in Excel. It returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.
How do you convert character to decimal integer?
In Excel it is the "code" function. For example, Code("A") = 65
What does today mean in Excel?
The TODAY function returns the current date when the function is executed. That would be when you open the document or when you insert the function for the first time in a cell.
When assigned to a cell what function returns a number that corresponds to the system date and time?
The function to show current date and time in Excel is =NOW().
What is the difference between the PMT and PPMT functions in Excel?
The PPMT function returns the amt. of interest in a specified instalment number whereas the PMT function returns the amt. of interest in every EMI payment.
