Hi Wade, I'd guess that the problem is that the SUM function result can't be passed to a string function unless it is first evaluated in a cell. Why not just use: =IF(SUM(C35:C40)>9,LEFT(STR(SUM(C35:C40)),1)+RIGHT(STR(SUM(C35:C40))),1) I'm assuming that you're using whole numbers and anything greater than nine will have two digits. tc
>________________________________ > From: Wade Smart <[email protected]> >To: [email protected] >Sent: Monday, November 21, 2011 8:52:38 PM >Subject: [users] using functions inside functions > >=IF(LEN(SUM(C35:C40))>1,LEFT(C56,1)+RIGHT(C56,1)) > >Im suming a set of numbers into a cell. >If the number is over 1 digit - and it always is, I want >to take the left and right digit and add them together. >This works if I do it in two steps but I dont want to >use up column space. > >Wade > >-- >-- >Registered Linux User: #480675 >Registered Linux Machine: #408606 >Linux since June 2005 >-- >----------------------------------------------------------------- >To unsubscribe send email to [email protected] >For additional commands send email to [email protected] >with Subject: help > > >-- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help
