August 6, 2020
I always cover IF in my seminars. And I always ask how people would solve the two-conditions problem. The results are often the same: 70–80% of people use nested IF, and 20–30% use AND. Just one time, in Virginia, a woman from Price Waterhouse offered the formula shown in this article.
August 5, 2020
When you need to do a conditional calculation, the IF function is the answer. It works like this: If
August 3, 2020
Here is an odd use for an array formula: Say that you don‘t want anyone to delete or insert any rows in one section of a worksheet.
July 30, 2020
Someone built this lookup table sideways, stretching across C1:N2. I realize that I could use HLOOKUP instead of VLOOKUP, but I prefer to turn the data back to a vertical orientation.
July 29, 2020
While NETWORKDAYS calculates the work days between two dates, the WORKDAY function takes a starting date and a number of days, and it calculates the date that is a certain number of work days away.
July 27, 2020
It certainly seems that if you work anything other than Monday through Friday or have a year ending any day other than December 31, a lot of things in Excel don’t work very well.
July 23, 2020
The Function Arguments dialog shown above is cool, but in real life, when you have to nest functions, how would you use this dialog?
July 22, 2020
There are 400+ functions in Excel. Instead of taking 450 pages to describe every function, I am going to teach you how to find the function that you need.
July 20, 2020
Inquire was developed by a company called Prodiance that offered the slick Spreadsheet Compare tool for $145 per person per year. The Excel team liked it so much that Microsoft bought out Prodiance and gave the tool for free to anyone who is on Pro Plus, Professional Plus, or Enterprise Level E3.
July 16, 2020
I previously explained how to Trace Precedents to See What Cells Flow into a Formula. Sometimes you have the opposite problem: You want to see which cells rely on the value in the current cell.
July 15, 2020
If you need to see which cells flow into a formula, you can use the Trace Precedents command in the Formula Auditing group on the Formulas tab.
July 13, 2020
If you are going to be auditing the worksheet, it would help to mark all of the formula cells.