I need to do this in excel. i have no idea what formulas to use. please help 6.

Question

I need to do this in excel. i have no idea what formulas to use. please help

6. Prepare a worksheet with suitable headings that shows in the first column names of your friends. The second column shows last four digits of their respective phone numbers. Enter at least names of eight friends and their respective phone numbers. Your task is to calculate a single digit lucky number for each of your friends based on his/her phone number. You will calculate the lucky number by repeated adding of the phone number digits as shown below:

2820 => 2+8+2+0 =>12 => 1+2 => 3

Explanation / Answer

With Kutools for Excel’s Sum numbers in a cell formula, you can quickly sum all digits of a number together in a cell.

Formula Helper - Sum numbers in a cell.

By this 2820 u will get ans 12
repeat again u will get 3

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects