Hi all,
I have a problem working with excel (quikoffice premier 6.2.217) on my E90:
a formula I created on my PC does not work on the E90. It is a "Logical" formula in the style: "=IF(a;b;c)", in which 'a' is a logical test; if the test is true then 'b' is the outcome, otherwise 'c' (if 'a' is untrue). Nothing special about this formula, but I made it a little more complex with some more logical tests in the formula added. This formula works fine on my PC, but it does not work on the E90.
Is there a maximum to the amount of logical tests that can be calculated on the E90??
I have inserted a copy of this formula in the attached excelsheet (this sheet I normally use on holidays with friends, in order to calculate the costs during the trip). This sheet works OK on the PC, but produces half the supposed outcome on the E90 (try it yourself, it will leave one of the logical tests out).
Does somebody have a clue to this or is this a shortcoming in QuickOffice (bye the way: it worked perfect on my 9210i when I used that years ago!!).
Thnx!
Frank
E90 excel problem
I do believe that there is mentioned somewhere that QuickOffice doesn't support nested IF's (or it is at least very limited).
I do believe however that it is possible to "overcome" this by splitting the contents over 2 or more cells:
Cell A1:
=IF(a;b;IF(c;d;e))
Would become (I think):
CellA1:
=IF(a;b;Cell B1)
Cell B1:
IF(c;d;e)
Where you can then hide column B if you like.
Hope this was some help!
Hi Gymbo,
That's a very neat solution! Never thought about that. I will try that right away!
But more important is your suggestion that QuickOffice doesn't handle nested IFs; I was thinking I was doing something wrong.
Let's see if the E90 supports your 'Columbus egg' :icon14:
Thanks
Frank