howtogeek at February 11th, 2014 08:03 — #1
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:
dnlsrl at February 11th, 2014 10:54 — #2
Kind of Off-topic
HTG guys, can you add a category link for an easy access to these lessons? Awesome work here!
geek at February 11th, 2014 17:47 — #3
We're definitely going to be adding the proper navigation for all Geek School series.
phershirley at February 12th, 2014 12:13 — #5
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.
geek at February 12th, 2014 13:30 — #6
Thanks, good catch. Updated the post.
christosg8 at February 12th, 2014 16:51 — #7
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...
jwoolley at February 15th, 2014 12:33 — #8
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)))
system at February 21st, 2014 08:03 — #9
This topic was automatically closed after 10 days. New replies are no longer allowed.