Let's see the if statement in action in the simplest use case, when the value of a cell is determined between two options based on the value of a different cell.įor example, let's say that we have a list of projects, the percentage progress on each of them, and we want to automatically set the string to 'In progress' or 'Finished'. How to conditionally set the value of a cell in Excel

value_if_false is an optional argument that determines the value in the case that logical_test is false.

value_if_true is an optional argument, and it is what the expression evaluates to in case logical_test is true, and.

logical_test is an expression that evaluates to TRUE or FALSE,.

The syntax is IF(logical_test,, ), where You can still edit all other cells.The IF function in Excel is an inestimable ally when we need to implement conditional logic, that is when we need different results depending on a condition.

The password for the downloadable Excel file is 'easy'. To edit these cells, you have to unprotect the sheet.

On the Protection tab, check the Locked check box and click OK.Īgain, locking cells has no effect until you protect the worksheet.Ĭell A1 and cell A2 are locked now. Right click, and then click Format Cells (or press CTRL + 1).Ħ. For example, select cell A1 and cell A2.ĥ. On the Protection tab, uncheck the Locked check box and click OK.Ĥ. To lock specific cells in Excel, first unlock all cells.

To unprotect a worksheet, right click on the worksheet tab and click Unprotect Sheet. On the Protection tab, you can verify that all cells are locked by default.Īll cells are locked now. Right click, and then click Format Cells (or press CTRL + 1).ģ.

Lock cells with formulas in excel 2016