Originally published at: http://www.howtogeek.com/school/microsoft-excel-formulas-and-functions/lesson2/
In this lesson, we introduce you to basic rules for creating formulas and using functions. We feel one of the best ways to learn is through practice, so we provide several examples and explain them in detail. The topics we will cover include:
Kind of Off-topic
HTG guys, can you add a category link for an easy access to these lessons? Awesome work here!
We're definitely going to be adding the proper navigation for all Geek School series.
I even wrote that incorrectly, this is what I meant to show you. This is what you wrote, "Rows run vertically and columns run horizontally. To remember which is which, think of a column holding up a roof – columns go up-down and thus rows go left-right."
It just is a small mistake but I thought you might like to know. Thanks.
Thanks, good catch. Updated the post.
What about this one = -1 ^ 3?
Then answer is -3 because the computer calculated = (-1) ^ 3 = -1 -1 -1 = -1.
You found the answer right but made a little mistake...
Anyway GREAT articles and great job guys... Thank you SO much for your effort...
It's difficult to proof-read and correct everything. Here are two more:
Under Operator Order Precedence:
% -- Percent, means multiply by 100. E.g., 0.003 = 0.3%
% -- Percent, means divide by 100. E.g., =0.3% yields 0.003
Near the end of the lesson:
=RIGHT(A3,LEN(A3) - FIND(",",A3) - 1)
=RIGHT(A3,LEN(A3) - FIND(",",A3))
or even better
=TRIM(RIGHT(A3,LEN(A3) - FIND(",",A3)))
This topic was automatically closed after 10 days. New replies are no longer allowed.