Validating formula results in excel 2016

Rated 4.21/5 based on 721 customer reviews

So we can see how to program our decision for the green light and red light, but what if the light is yellow???This is where we can get in trouble in life (and Excel).Writing your first IF formula in Excel is an exciting moment.It gives you the feeling of how you can program Excel to make it interactive.

We are testing for a condition (the color of the light), then taking an action based on whether the condition is TRUE or FALSE.Before you write your first IF statement (formula), it's best to get an understanding of how Excel makes comparisons.Type your first name in cell A1 and your last name in cell B1.The following formula will return TRUE.=”Excel Campus” = “excel campus”What if you want to return a result other than TRUE or FALSE? For the 1st argument, Logical Test, we can use the same formula we used above to compare two values.If the logical test evaluates to TRUE, then the result of the IF function will return whatever you put in the 2nd argument (Value If True).

Leave a Reply