|
Learn to love Excel - one cell at a time. Tutorials for beginners, tips for experienced users
| OLYMPICS, FAILURE AND RYAN LOCHTE- 2012-08-02 05:44:34-04 |
I’vwe been watching the Olympics sporadically over the last week or so. The big battle has been in the pool amongst the swimmers. Now I have to say I’m no swimmer. I didn’t learn as a child and while I did try it again, my instructor – try as she did – was unable to [...]
Read more...
|
| EXCEL IF OR STATEMENTS- 2012-08-02 06:50:44-04 |
In a previous blog posting, I showed you how to set up an If statement in Excel. In this blog posting, I am going to show you how to nest an OR function into an IF function (the technique can be used equally well with a NOT, AND, TRUE, FALSE functions). Essentially the OR function [...]
Read more...
|
| IF STATEMENTS IN EXCEL- 2012-08-02 06:54:05-04 |
One of the most powerful tools in Excel is the if statement. An if statement has the following structure: test a question, if the answer is “Yes”, do one thing. If it’s “No”, do something else. For example, a use of it would be in exam results – have you scored over 50% – yes, [...]
Read more...
|
|