sum of squares excel formula, =SUMSQ(..)
I didn't know this until a study friend shared this with me. Excel has this function available, =SUMSQ( ). This function returns the sum of the squares of the arguments. This has made calculating the RBC requirement much faster, and my work is much cleaner. Hope this helps!
Comments
Very good, thank you for sharing!
A cautionary note. The Exam provides an app similar to Excel, but it may not include all the Excel functionalities. So, the SUMSQ() function may not be available in the Exam.
Thank you. I've been meaning to get more practice with the exam's version of excel. I logged on today, and it does appear to be there.
Great tip, thanks!
sumproduct does the same thing