Sorry again. Just closed the test-sheet and on save-request I saw two
inconsistant results.
Andreas Saeger wrote:
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)))
which is in pseudo-code:
=IF($G=1;
4/24
;
IF($E=1;
IF($G=0;
ABS($S-$P)*5/4
;
0
);
IF($G=0;
ABS($S-$P)
;
0
)
)
)
</pseudo-code>
The confusing thing is twice IF($G=0;...
<pseudo-code>
=IF($G=1;
4/24
;
IF($G=0;
ABS($S-$P)*IF($E=1;5/4;1)
;
0
)
)
</pseudo-code>
Y109: =IF($G109=1;4/24;IF($G109=0;ABS($S109-$P109)*IF($E109=1;5/4;1);0))
Does this help?
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]
