Del S | search
Click here to view Del S news from 60+ newspapers.
Bookmark or Share- Using IF with AND, OR, and NOT functions in ExcelIn Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False.
- Keeping leading zeros and large numbers - Microsoft SupportExcel automatically removes leading zeros, and converts large numbers to scientific notation, like 1.23E+15, in order to allow formulas and math operations to work on them. This article deals with how to keep your data in its original format, which Excel treats as text.
- Display the relationships between formulas and cellsTo assist you in checking your formulas, you can use the Trace Precedents and Trace Dependents commands to graphically display and trace the relationships between these cells and formulas with tracer arrows, as shown in this figure. Follow these steps to display formula relationships among cells: Click File > Options > Advanced.
- Overview of formulas in Excel - Microsoft SupportIf you’re new to Excel, or even if you have some experience with it, you can walk through Excel’s most common formulas in this tour. With real-world examples and helpful visuals, you’ll be able to Sum, Count, Average, and Vlookup like a pro.
- Turn off Scroll Lock - Microsoft SupportIf Scroll Lock is on, your cursor moves between columns and rows, not cells. Here's how to turn off Scroll Lock.
More
