Formula If. To use the if excel worksheet function select a cell and type. For your excel if formula to display the logical values true and false when the specified condition is met and not met respectively type true in the value if true argument.
To use the if excel worksheet function select a cell and type. For example select cell g3 above. You can always use the evaluate formula tool to step through your if formula.
Otherwise the expression evaluates to false.
If a1 100 a1 5 a1 7. Get the if function to display logical values true or false. If logical test value if true value if false logical test is any value or expression that can be evaluated to true or false. The if function can return another formula as a result.