nding cases,
=VALUE(LEFT(TRIM(QUOTIENT(SUM(C35:C40),10)),1))+MOD(SUM(C35:C40),10)
-Original Message-
From: Dennis E. Hamilton [mailto:dennis.hamil...@acm.org]
Sent: Tuesday, November 22, 2011 18:37
To: 'Anthony Chilco'; users@openoffice.org
Subject: [users] Re: using functions i
-Original Message-
From: Anthony Chilco [mailto:anthonychi...@yahoo.ca]
Sent: Tuesday, November 22, 2011 18:02
To: users@openoffice.org
Subject: [users] Re: using functions inside functions
Hi Wade,
The programmer's answer is
=QUOTIENT(SUM(C35:C40);10)+MOD(SUM(C35:C40);10)
tc
Whatever hap
Hi Wade,
The programmer's answer is
=QUOTIENT(SUM(C35:C40);10)+MOD(SUM(C35:C40);10)
tc
Whatever happened to DIV?
>
> From: Wade Smart
>To: users@openoffice.org
>Sent: Tuesday, November 22, 2011 7:52:53 AM
>Subject: [users] Re: using functi
At 06:52 22/11/2011 -0600, Wade Smart wrote:
On Tue, Nov 22, 2011 at 02:02, Brian Barker wrote:
> =SUM(C35:C40)-9*INT(SUM(C35:C40)/10)
Brian, the values of C35 - 40 are (right now)
4,1,5,9,5,3 = 27
2 + 7 = 9
But when I used your function it produces 0
I'm not sure what you are doing wrong, b
On Tue, Nov 22, 2011 at 02:02, Brian Barker wrote:
> =SUM(C35:C40)-9*INT(SUM(C35:C40)/10)
Brian, the values of C35 - 40 are (right now)
4,1,5,9,5,3 = 27
2 + 7 = 9
But when I used your function it produces 0
Wade
Jacek, Im on Ubuntu and use , not ;. Thanks.
--
--
Registered Linux User: #480675
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 ad
W dniu 2011-11-22 02:52, Wade Smart pisze:
> =IF(LEN(SUM(C35:C40))>1,LEFT(C56,1)+RIGHT(C56,1))
=IF(LEN(SUM(C35:C40))>1;LEFT(C56;1)+RIGHT(C56;1))
Jacek Szymona
--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For a
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 grea
