Posted to microsoft.public.excel.programming

Michael168[_70_] Michael168[_70_] is offline

external usenet poster

Posts: 1

Root of Sum

I like to sum col A:C in col D which give the root of the sum.

e.g.
A1=1 B1=9 C1=9 D1=1 (The root of 1 comes from 19=1+9=10=1+0=1

Can someone show me the formula how to get the answer for col D?

Thanks
Michae

--
Message posted from http://www.ExcelForum.com

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
square root	Mitch Easterby	Excel Worksheet Functions	6	May 22nd 09 03:00 AM
square root	marpad	Excel Discussion (Misc queries)	4	March 23rd 07 08:09 PM
Cube root?	Scott	Excel Worksheet Functions	6	November 30th 05 10:34 PM
Nth Root	Samir[_2_]	Excel Programming	1	February 18th 04 01:55 PM
Cubic Root	Cbarney	Excel Programming	3	October 16th 03 03:47 PM

All times are GMT +1. The time now is 09:40 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us