Welcome Guest.


How does Excel calculate the sum of mantissas with mantissas

Asked by: Roger Edwards 164 views IT September 28, 2020

How to calculate the sum of the mantissas of numbers greater than 1? Please advise! ! !

1 Answers

  1. +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.

    Deborah Hunter- September 28, 2020 |