Think about arrayformula as a replacement for copy-paste within spreadsheets. Type the equals sign. To start open your Google Sheets spreadsheet and then type IF test value_if_true value_if_false into a cell.
Here Google Sheets SWITCH formula is far better than CHOOSE Formula.
More complex formulas can contain several mathematical operators such as 528. Google Sheets will automatically adjust the formula of the first cell in the following rows and it will apply the same calculations with the respective row numbers until the row where you dragged it down. This article explains how to use the Google Sheets If function. Click or tap the cell where you want to place the formula.