How to determine the values?

Office

Question:Example 1number in cell A1 is assigned to the-4.6I would like to retrieve 4 in 6 and cell B1 in cell C1.Example 2number in cell A1 is assigned to 12.86I would like to retrieve 12 in 8 and cell B1 in cell C1.Example 3number in cell A1 is assigned to the-32.975I would like to retrieve 32 9 and cell B1 in cell C1.Anyone have suggestions?Thanks in advance for suggestionsAnswer:C1= INT (ABS(A1...Read More

Posted: 27 Jan 2012

Tags: How to determine the values How determine the values