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.
- CrackBerry User
01-11-2013, 04:04 PM #2
- 92 Posts
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?
- CrackBerry User
01-11-2013, 06:00 PM #4
- 97 Posts
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.
- CrackBerry Addict
01-11-2013, 11:51 PM #69800 (Torch), 9780 (Bold). Playbook
- 941 Posts
- CrackBerry Master
01-12-2013, 11:37 AM #9
- 1,266 Posts
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.
- By spike12 in forum PlayBook Apps & GamesReplies: 0Last Post: 02-22-2012, 06:19 PM
- By rufluffy in forum RogersReplies: 3Last Post: 10-09-2008, 02:50 PM
- By libuff in forum BlackBerry OS AppsReplies: 14Last Post: 09-02-2008, 11:51 PM
- By hvnhlpr in forum BlackBerry Curve 83xxReplies: 2Last Post: 09-02-2008, 12:04 PM
- By Questionmark in forum Leaked/Beta OSReplies: 4Last Post: 08-01-2008, 08:13 PM