howtogeek at February 13th, 2014 08:02 — #1
Originally published at: http://www.howtogeek.com/school/microsoft-excel-formulas-and-functions/lesson4/
In this lesson we’ll discuss categories of functions – what they do and various examples – and to illustrate how they work, we’ll show you several example spreadsheets. We encourage you to follow along by creating your own spreadsheets.
moree at February 13th, 2014 17:42 — #2
Your logic re Jane's wardrobe choices assumes that Jane is excessively boy-crazy and will wear a sexy outfit even when it is raining. The modern, more "liberated", girl will choose practicality over hormonal surges and therefore use this formula to guide her;
The excel lesson to be learned here is that in a nested IF statement it matters which IF comes first. In your example the first IF statement tested whether either of the boys had a girlfriend. If the answer was FALSE then Jane would tart up regardless of the weather.
jwoolley at February 15th, 2014 14:04 — #3
Under Math and Financial Functions:
DEGREES -- ... to convert degrees (e.g., 360⁰) to radians (e.g. 2π)
DEGREES -- ... to convert radians (e.g., 2π) to degrees (e.g., 360⁰)
GCD -- ... For example, GDC(5,15)=5, ...
GCD -- ... For example, GCD(5,15)=5, ...
RAND(23) -- Generate a random ...
RAND() -- Generate a random ...
Under Date and Time Functions:
=WEEKDAY(...) -- ... Extracts the date as a number....
=WEEKDAY(...) -- ... Extracts the day as a number....
Under Example: When to Take Vacation:
should be simply
but since you leave Saturday for 2 or 3 weeks vacation, you should probably return home on Sunday, so make it
Also, this assumes B2>=A9; otherwise, you're fired.
geek at February 16th, 2014 12:24 — #4
Thanks, will update the article.
system at February 23rd, 2014 08:02 — #6
This topic was automatically closed after 10 days. New replies are no longer allowed.