Using IF True/False in excel

Provided that you remember that True value always precedes False value, these two values can be almost anything. If desired, a simple number could be returned, a calculation performed, or even a piece of text entered. Also, the type of data entered can vary depending on whether it is a true or false result. You may want a calculation if the logical test is true, but a message displayed if false. (Remember that test to be included in functions should be enclosed in quotes). Taking the same logical test mentioned above, if the sales figure meets or exceeds the target, a Bonus is calculated (e.g 2% of sales). If not, no bonus is calculated so a value of zero is returned. The IF statement in column D of the Example reads as follows;

=IF(B2>=C2,B2*2%,0)

You may, alternatively, want to see a message saying “ No Bonus”. In this case, the true value will remain the same and the false value will be the text string “No Bonus” ;

=IF(B2>=C2,B2*2%,"No Bonus")