1Answers
How does Excel calculate the sum of mantissas with mantissas
Asked by: Roger Edwards 164 views IT
How to calculate the sum of the mantissas of numbers greater than 1? Please advise! ! !
Welcome Guest.
Asked by: Roger Edwards 164 views IT
How to calculate the sum of the mantissas of numbers greater than 1? Please advise! ! !
+1Votes
Q7 to Q5: =SUM(MOD(Q7:Q15,1))
T7 to T17: =SUM(MOD(T7:T17,1))
ctrl +shift+enter Press the three keys simultaneously.