This discussion is archived
1498 Views 5 Replies Latest reply: Mar 3, 2010 10:09 AM by KOENIG Yvan
Currently Being ModeratedMar 1, 2010 4:53 AM (in response to Frosty Noir)
Frosty Noir wrote:
When I try to create an equation it just won't calculate!! (it usually just lists the equation exactly as I typed it (eg. A/11) What part / column do I need to highlight, how and where do I type the equation and how can I get my answers to appear in the above locations?
Put an = in front of the formula. Otherwise it is treated as text, not a formula.
=A/11Mac Pro 2008, Mac OS X (10.5.6)
Currently Being ModeratedMar 2, 2010 1:39 AM (in response to Badunit)Thank you! That equation seems to give me one total figure for the whole column. Do you know how to get individual answers for each entry in column A (ultimately to list the answers in each adjacent cell in column B)??
Currently Being ModeratedMar 2, 2010 3:04 AM (in response to Frosty Noir)Select the first cell where you wrote the equation(=A/11) and then press and hold the small circle from the right lower corner of the cell, and then drag downward to the other cells in the column B and the results will be listed.iMac, Mac OS X (10.6.2)
Currently Being ModeratedMar 2, 2010 5:33 AM (in response to Frosty Noir)=A/11 does not give you "the total figure for the whole column" divided by 11. If you put this formula in a cell in cell B2, it is the same as =A2/11. In cell B3 it is the same as A3/11. Etc.
If the formula is expecting a range it uses "A" as the entire column. If it is expecting a single cell, it uses A as described above. It is pretty handy this way.Mac Pro 2008, Mac OS X (10.5.6)
Currently Being ModeratedMar 3, 2010 10:09 AM (in response to Badunit)If I understand well, I guess that the OP inserts the formula ( _*not an equation*_ ) in a cell of a footer row.
Yvan KOENIG (VALLAURIS, France) mercredi 3 mars 2010 19:09:55To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !, Mac OS X (10.4.11)