PERFECT returns the word PERFECT in cell C2 if B2 is larger than 1000. We can add the text values according to our preferences either by using the CONCATENATE function in excel or ampersand. Example 3 Excel IF Statement.
If we want to insert a formula in Excel then we need to get into the edit mode of the cell where we want to apply and then type equal sign.
You need to drag towards the right to apply the formula to the entire row. We will see how this equation can be solved with the Goal Seek feature. Type any value in B3 and c3 cells you will see the answer in the D3 cell. Firstly select the whole Column C secondly enter the formula A1385 and then press the Ctrl Enter keys together.