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 » Formulas
Formulas
Resolved · Low Priority · Version Standard
RE: formulas
Hello Shirley,
Hope you enjoyed your Excel training last week.
To create a formula there are several concepts and principals that you need to understand and be familiar with using.
The most basic formula is what you can do on a calcuator. The only difference is that you START with the equals sign "=", and then put in the numbers and opertators (+ or - or / or *).
That would look like: =1+2
The nesxt step is to use CELL REFERENCES in place of the numbers. This allows you to have dynamic formulas, in which the answer changes when the inputs change.
Lets say that that cell A1 has a value of 2, and cell A2 has a value of 4. If you add those together, you get 6.
So your formula entered into cell A3 (for example), will look like this:
=A1+A2
Now if for whatever reason the value in cell A1 changes from 2 to 3, then the answer you get via the formula will automatically change. The answer will now be 7.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Richard
Microsoft Office Specialist Trainer
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:Status Bar FunctionsWhen using the SUM, MIN, MAX, AVERAGE and COUNT functions, the result of such calculations are displayed in the worksheet. |