8:46
Bob Flisser
Bob Flisser has authored many courses and books about Microsoft, Adobe and Apple products, and has been a computer trainer since the 1980s.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to use Excel's many other decision-making functions.
Video Steps
1. Enter the following values to create a tax table:
Enter into L2: NJ tax
Enter into M2: 7%
2. Create a new header for column H:
Enter into H5: Tax
3. Enter the IF function:
Enter into H6: =IF(C6="NJ", G6*$M$2,0)
4. Enter the formula:
Press Enter. The value is 0 because this customer is from Michigan.
5. Use AutoFill to copy this formula down the page:
Click back on H6.
6. Position the mouse pointer on the dot in the lower right corner of the cell so the mouse pointer becomes a crosshair.
7. Double-click..
8. Scroll down the page.
9. Double-click H6.
This way, you can edit the formula.
9. Rewrite the formula so that the value-if-false (zero) is just a set of empty quotation marks.
10. Enter the rewritten formula, then AutoFill down as you did before.
0 Comments
Suggested Videos
Pseudo random numbers are right at hand in VBA. Obtaining truly random numbers, however, requires an external source. One is the Swiss Quantis QRNG Chip. The output from one of these has been made public by ETH Zürich, and here we present a complete…
- Microsoft Office
- Microsoft 365
- Microsoft Access
- Math / Science
- VBA
- Microsoft Excel
Recently I have answered a question on how to distribute hours evenly between two dates. I thought this isn't that difficult to do that in Excel with formula, but what I see from this question, it could be applied to other similar scenarios. So, let…
