How To Input Formula In Excel Complete Guide

how to input formula in excel. To do that first select the cells of the column where you want to insert the formula along with the formulated cell. Type an open parenthesis if necessary.

Eko Hariyanto Ms Excel Excel Training London Uk Wide Excel Course London Microsoft Excel Tutorial Microsoft Excel Excel Tutorials from www.pinterest.com

To start a new line double-click the cell which contains the text. Select the cell you want to enter the formula in. Select the C2 cell.

Select the C2 cell.

PERFECT returns the word PERFECT in cell C2 if B2 is larger than 1000. For example if sales total more than 5000 then return a Yes for Bonus Otherwise return a No for Bonus. PERFECT returns the word PERFECT in cell C2 if B2 is larger than 1000. Things to Remember Formula with Text in Excel We can add the text values according to our preferences either by using the CONCATENATE function in excel or ampersand symbol.