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
