excel microsoft training - Excel

Hello Erin

Hope you are ok

The reason for using IF function would be if you need to check certain criteria in a cell or a group of cells and return a true or false answer. Examples of this type of formula look like this:

=if(d4<=h7,"yes","no")

if you read this through it would be like this

if D4 is less than or eqaul to H7 if true say YES if not say NO

IF functions work in 3 parts 1. A test 2. What to do if correct.
3. What to do if wrong

hope this explains thing a bit clearer for you

Mark East