Formula Tricks - SUMPRODUCT, POWER, ROUND, MROUND

  • SUMPRODUCT() for computing weighted average
  • POWER() and ^ for exponential/compounding/discounting computations
  • =ROUND(A1/50,0)*50 will yield nearest 50 (multiple of 50) and similar technique can be used to solve for nearest 5, 10, 25 and any such combinations. It is more useful since =MROUND() does not work for +ve and -ve numbers simultaneously.

  • Get free tutorials, updates, tips and tricks and much more.

    Subscribe to our Click her to go to our YouTube Channel channel
    Like us on Click here to go to our Facebook Page
    Follow us on Click here to go to our Twitter Page Click here to go to our Google+ Page

Complete and Continue