All About Symbian - Nokia (S60) and Sony Ericsson (UIQ) smartphones unwrapped

  #1  
Old 03-10-2010, 01:21 PM
babiroessa babiroessa is offline
Registered User
 
Join Date: Jul 2005
Posts: 4
babiroessa is on a distinguished road
Question E90 excel problem

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
Attached Files
File Type: zip Cost Handling on Trip - Excel document.zip (5.5 KB, 314 views)

  #2  
Old 05-10-2010, 12:55 AM
gymbo gymbo is offline
Registered User
 
Join Date: Oct 2010
Posts: 1
gymbo is on a distinguished road
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!

  #3  
Old 05-10-2010, 08:27 PM
babiroessa babiroessa is offline
Registered User
 
Join Date: Jul 2005
Posts: 4
babiroessa is on a distinguished road
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'
Thanks
Frank
Ads
 

Bookmarks

Tags
e90, excel, formula does not work, problem

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Nokia e90 Wi-Fi Problem jeffmohd Nokia E90 6 30-08-2009 10:01 AM
E90 Problem W7NNS Nokia E90 4 03-08-2009 01:36 PM
E90 & Belkin Router: Solution to 'No Gateway Reply' timsalmon Nokia E90 3 08-11-2007 12:41 PM
E90 - IP Passthru / Using PC internet access on E90 via PC suite quicksilver Nokia E90 6 12-08-2007 06:00 PM
Problem with open. EXCEL files on 9300, plz.help jimmy-floyd Nokia 9300 and 9500 0 16-05-2005 01:55 PM



All times are GMT. The time now is 02:39 AM.


vBulletin skins developed by: eXtremepixels
Powered by vBulletin® Version 3.8.0
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright Notes || Contact Us || Privacy Policy