Re: using functions inside functions

At 19:52 21/11/2011 -0600, Wade Smart wrote:
>=IF(LEN(SUM(C35:C40))>1,LEFT(C56,1)+RIGHT(C56,1))
>
>I'm summing a set of numbers into a cell.  If the number is over 1 
>digit - and it always is, ...

If it always is, you can dispense with the test.

>... I want to take the left and right digit and add them together.

Is the sum always two digits, not more?  If so, use:
=SUM(C35:C40)-9*INT(SUM(C35:C40)/10)

This will also work with single-digit sums, in any case.

I trust this helps.

Brian Barker

-- 
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help