98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum 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
Resolved · 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 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Create Equations in Excel 2010Here's how to create basic mathematical |