How to Evaluate an Excel Function
Logical functions can be calculated with the "Evaluate Formula" tool in Microsoft Excel. This is helpful in seeing how each part of the logical statement is assessed. Use this tool to identify errors in function, or to enhance it. Learn how to evaluate an Excel function by following the steps below.
Other People Are Reading
Instructions
-
-
1
Open a new workbook in Microsoft Excel. Enter the data in the function. For example, enter a student's test scores in cells A1 to A4.
-
2
Click on a blank cell, and type in the function. To determine whether a student passed a course by having an average test score of 70 or higher, for example, use the following formula to display either "Pass" or "Fail": =IF(AVERAGE(A1:A4)>=70,"Pass","Fail").
-
-
3
Go to the "Formulas" tab, and click on "Evaluate Formula." Next, click on the "Evaluate" button to see how each part of the logic is assessed. Continue to click on "Evaluate" until the final results appear. To reactivate the feature, click on "Restart."
-
1
