Steve Scott ![Excel Logical Test Using Multiple If Statements in Excel [AND/OR]](https://spreadsheetplanet.com/wp-content/uploads/2023/02/Excel-Logical-Test-Using-Multiple-If-Statements-in-Excel-ANDOR.png)
To test certain conditions, people use If statement. The If() function is used to perform logical tests and to evaluate conditions that will show two outcomes. This Excel IF statement …
I was recently asked if there is a way to set column width in inches in Excel. This was for a template this person was creating where they wanted the …
When you are working on a large number of data then you will encounter a few duplicate entries. Sometimes these duplicate values are very useful but many times you want …
![How to Lock Cells in Excel [Mac, Windows]](https://spreadsheetplanet.com/wp-content/uploads/2023/02/How-to-Lock-Cells-in-Excel-Mac-Windows.png)
If you are protecting a worksheet, then that means you are locking all the cells. You cannot perform any editing on those cells. To perform the editing of the cells, …
![How to Open Excel File [xls, xlsx] Online (for FREE)](https://spreadsheetplanet.com/wp-content/uploads/2023/02/How-to-Open-Excel-File-xls-xlsx-Online-for-FREE.png)
When you open an Excel file online, you will find a new workbook automatically displayed. The workbook contains various worksheets that hold actual data and information. Initially, the workbook opens …
Sometimes, you may have a dataset where there are empty/blank cells in a dataset that should have been filled with the same value. Below is a common example where the …
When we talk about learning Excel, we almost always think of videos and written tutorials. While these are great ways to learn Excel, books can do a much better job …
When you’re working with data in Excel, sooner or later you will have to compare data. This could be comparing two columns or even data in different sheets/workbooks. In this …
Watch Video – How to Remove Formulas in Excel Sometimes you may want to remove formulas from the worksheets but keep the data. It is also recommended to remove formulas …
We use the IF statement in Excel to test one condition and return one value if the condition is met and another if the condition is not met. However, we …
Sometimes, you may get data (text or numbers) that have dashes (or hyphens) in it. If you want to remove these dashes in Excel, you can use a couple of …
If you have worked with Excel formulas, I am sure you have noticed that sometimes there is a $ symbol as a part of the cell references. If you’re wondering …