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