James McKenzie wrote:
Andreas Saeger wrote:
The second formula has non-matching brackets.
Andreas:
I don't see it and I just spent fifteen minutes picking it apart.
James M.
OOops, Sorry for wasting your time. I made some mistake. The code-editor
I used did not work with ";" as list-separator and Calc's function
wizzard had a red entry as well. Today I spent some time with that
formula and it works well.
Then I toggled the formula to absolute columns (Shift+F4), copied it to
the right and did the following steps:
X109:
=IF($G109=1;4/24;IF($E109=1;IF($G109=0;ABS($S109-$P109)*5/4;0);IF($G109=0;ABS($S109-$P109);0)))
Y109:
=IF($G109=1;4/24;($E109=1)*IF($G109=0;ABS($S109-$P109)*5/4;($G109=0)*ABS($S109-$P109)))
Z109: =IF($G109=1;4/24;($E109=1)*IF($G109=0;5/4;1)*ABS($S109-$P109)))
or may be:
AA109: =IF($G109=1;4/24;($E109=1)*(1+($G109=0)*1/4)*ABS($S109-$P109)))
Well, it could be shortened even more, but this one is still readable.
Changing input-values G and E returns the same results in V to AA.
W109 is no longer used. It's just an informational display-string. I
prefer it like this: =CHOOSE(SIGN($P109-$S109)+2;"-";"~";"+")
Btw: This simple macro converts localized formulas:
http://www.oooforum.org/forum/viewtopic.phtml?t=23270
I use it with Ctrl+Shift+F1
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
