

Have you ever tried to build a formula containing several embedded IFs? Complicated, right? Let us start by building a formula with a simple IF, in the selected cell. 

After entering all the data, we will press the OK button.  
You have just created your first IF formula, in the simplest possible manner. Now let us take a look at a more elaborate example: 

Then we click on the Next button to continue building our formula. The following dialogue box will be displayed:  
Note that in the first part of the IF (is it greater than 10?) there are two possible answers: if True: ">10", of False: "<=10" Finally, we press the OK button to see the results. 



Notice how complex the formula is, and how difficult it would have been to do it manually. Use this tool and have fun building your formulas. 
