Column D is where we want the formula to return the result if the cells in Column C are greater than 1000įigure 2: Setting up the Data If a Cell is Greater than 1000.Column C contains the result of the multiplied values in Column A with Column B.We will input the cost per kg into Column B.We will set up the data by inputting the WEIGHT into Column A. The steps below will walk through the process.įigure 1: How to Check if a Cell is Greater Than Syntax The IF function returns TRUE if the condition is met and FALSE if otherwise. We can use the IF Function to check if a cell has a value that is greater than the specified criteria.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |