excel in courses - what basics formulas

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel in courses - What are the basics for formulas

excel in courses - What are the basics for formulas

resolvedResolved · Low Priority · Version Standard

Cathy has attended:
Excel Intermediate course

What are the basics for formulas

I have not covered the basics is there any advice you can give me

RE: What are the basics for formulas

click the fx to the left of the formula bar near the top of your workbook for a list of available formulae and play around!!

most commonly used formula I reckon is the if statement.


in cell B1, type the following:

=if(A1>10,"big number","small number")

this will return "big number" or "small number" based on the value in cell A1. if it's a number less than or equal to 10, it will return "small number" in cell B1, if it's a number larger than 10, it will return "big number"

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Create Equations in Excel 2010

Here's how to create basic mathematical
equations in your Excel 2010 worksheet.

1) On the Ribbon, click the Insert tab
2) In the Symbols group, click the arrow next to Equation
3) Select from the equations and the equation will be inserted in a text box

Or you can create your own equation:

1) Insert and select the text box
2) On the Ribbon, click the Insert tab
3) In the Symbols group, click Equation
4) The Equation Tools Design Ribbon will now be displayed

View all Excel hints and tips


Server loaded in 0.09 secs.