Welcome to the CrackBerry Forums Create Your Account or Ask a Question Answers in 5 minutes - no registration required!
Results 1 to 9 of 9
  1. GV2012's Avatar
    CrackBerry Abuser

    Posts
    332 Posts
    Thread AuthorThread Author   #1  

    Default Simple math functions on doc to go?

    So, I am messing around with spreadsheet in docs to go but I can't seem to find the method for adding subtracting multiply the value of different cells the same way I would in regular excel ie +A5*C6=value. I see the functions list on the menu but they don't really give me what I am looking for.
    Anyone?
    Thanks
  2. GooseberryFool's Avatar
    CrackBerry Abuser

    Posts
    101 Posts
    #2  

    Default

    Hi
    I've just had a quick go, although haven't used this before, only MS Excel

    I put 2 in A1, then 3 in B1, the put "=sum(a1*b1)" without quotes, of course, into C1 and got "6"
    Same but with =sum(a1, b1) and got "5"

    Does that help in any way?

    Cheers
  3. GV2012's Avatar
    CrackBerry Abuser

    Posts
    332 Posts
    Thread AuthorThread Author   #3  

    Default

    I may have to try the equal sign to qualify as an formula because it seems that the formula carried over from download ss still has that in there even though the desktop excel will auto add =when putting in a computation.
  4. rmpb's Avatar
    CrackBerry Abuser

    Posts
    104 Posts
    #4  

    Default

    An equal sign is the likely solution for your problem. It tells the program that the contents of the cell are a formula. IIRC the "+" sign usage is legacy and the full version of Excel is probably looking after it on that basis. The Docs to Go version is pretty good, but no where nearly as full featured.
  5. GV2012's Avatar
    CrackBerry Abuser

    Posts
    332 Posts
    Thread AuthorThread Author   #5  

    Default

    Thanks all yes the= sign did the trick
  6. Angus_CB's Avatar
    CrackBerry Master

    Posts
    1,184 Posts
    Global Posts
    1,186 Global Posts
    #6  

    Default

    Quote Originally Posted by GV2012 View Post
    I may have to try the equal sign to qualify as an formula because it seems that the formula carried over from download ss still has that in there even though the desktop excel will auto add =when putting in a computation.
    Excel doesn't insert the = sign automatically if you just type a computation in the formula box. It does add the = sign automatically if you press the fx (Insert Function) button.
    Z30, Nexus 4, Kobo Arc 64GB, Playbook 16GB
  7. GV2012's Avatar
    CrackBerry Abuser

    Posts
    332 Posts
    Thread AuthorThread Author   #7  

    Default

    Quote Originally Posted by Angus_CB View Post
    Excel doesn't insert the = sign automatically if you just type a computation in the formula box. It does add the = sign automatically if you press the fx (Insert Function) button.
    that is not correct and yes it does add the =. I ve never put the = sign or pressed fx in for a calculation. Once you enter it in with only +Excel auto adds going forward. I've been using + only since Lotus 123
  8. rmpb's Avatar
    CrackBerry Abuser

    Posts
    104 Posts
    #8  

    Default

    Quote Originally Posted by GV2012 View Post
    I've been using + only since Lotus 123
    I was thinking that was a holdover from good old Lotus 123 days, but that was a while ago so I wasn't sure. Glad you mentioned it.
    Thanked by:
    GV2012 (01-12-2013) 
  9. SifJar's Avatar
    CrackBerry Master

    Posts
    1,373 Posts
    #9  

    Default

    Quote Originally Posted by GV2012 View Post
    that is not correct and yes it does add the =. I ve never put the = sign or pressed fx in for a calculation. Once you enter it in with only +Excel auto adds going forward. I've been using + only since Lotus 123
    I think Angus_CB meant if you didn't have the "+" there. Excel presumably supports the "+" for backwards compatibility, but what I think Angus_CB meant was that if you just type in a formula (e.g. "12+3"), Excel will do nothing with it, you need to put the "=" there (or a "+" apparently, this thread was the first I heard that that worked; I was always taught to use "=" in school IT lessons etc.).

    My assumption would be that, like myself, Angus_CB was previously unaware of being able to use "+", so thought you meant that Excel added an "=" to any formula, which is not the case, of course.
    UberCurrency - Free currency conversion app for PlayBook.

Similar Threads

  1. Help with Symbol font on Docs to go
    By spike12 in forum PlayBook Apps & Games
    Replies: 0
    Last Post: 02-22-2012, 06:19 PM
  2. Docs to go on 4.5
    By rufluffy in forum Rogers
    Replies: 3
    Last Post: 10-09-2008, 02:50 PM
  3. docs to go? included on curve? where?
    By libuff in forum BlackBerry OS Apps
    Replies: 14
    Last Post: 09-02-2008, 11:51 PM
  4. Doc to Go- Deleting Files on Device
    By hvnhlpr in forum BlackBerry Curve 83xx
    Replies: 2
    Last Post: 09-02-2008, 12:04 PM
  5. Can't Find Docs to Go on my new OS
    By Questionmark in forum Legacy Leaked/Beta OS
    Replies: 4
    Last Post: 08-01-2008, 08:13 PM

Posting Permissions