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.
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.
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.
Thanks, will update the article.
This topic was automatically closed after 10 days. New replies are no longer allowed.