2015-01-22 2:27 GMT+01:00 Alan B <[email protected]>: > On Wed, Jan 21, 2015 at 6:34 PM, Rod Huxley <[email protected]> wrote: > > > Also under what sub heading in the HELP area, can I find all the formula > > options. E.G +, /, –, *, sum, IF, etc > > > > Hello Rod - I see Brian has already provided formulas for you so I'll skip > that part of your question. > > Regarding "...what heading in help ... to find the formula options..." > > Open your Calc help, select the "Contents" tab, expand the "Spreadsheets" > branch, then the "Functions Types and Operators" branch and you can begin > exploring all the functions available there. > > The other branch to explore, under the "Spreadsheets" branch, is "Formulas > and Calculations". > > I think together those to branches will provide much of the information you > seek. >
Another approach could be to hit Ctrl+F2 when entering a formula. A dialogue opens in which you can explore and create formulas. Some fiddling around with it will hopefully make you understand how it works. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ
