{"id":234,"date":"2014-09-24T00:03:00","date_gmt":"2014-09-23T22:03:00","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=234"},"modified":"2024-05-30T16:15:25","modified_gmt":"2024-05-30T14:15:25","slug":"if-function-introduction","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/if-function-introduction\/","title":{"rendered":"IF Function: Introduction"},"content":{"rendered":"

What does it do? <\/strong><\/em><\/p>\n

It returns a value that you set if a condition is met, and a value if it is not met<\/p>\n

Formula breakdown: <\/strong><\/em><\/p>\n

=IF(Logical Test<\/span>,Value if True<\/span>,Value if False<\/span>)<\/p>\n

What it means: <\/strong><\/em><\/p>\n

=IF(The condition to be checked<\/span>, Value to be shown if the condition is met<\/span>, Value to be shown if condition is not met<\/span>)<\/p>\n

\n

The IF function<\/strong> is probably one of the most used Excel functions because it is easy to understand and very flexible when you apply it to real life situations.<\/p>\n

Here I will show you a couple of ways that you can use the\u00a0IF function<\/strong> to get you up and going.<\/p>\n

\n

Download excel workbook<\/i><\/span>If.xlsx<\/span><\/a><\/p>\n<\/div>\n

We want to show a Bonus<\/strong> value if sales are bigger than $3000<\/strong>, and No Bonus<\/strong> is shown if this condition is not met. Afterwards let’s try computing the 10% bonus<\/strong>!<\/p>\n

STEP 1:\u00a0<\/strong><\/span>We need to enter the IF function<\/strong> in a blank cell:
\n=IF(<\/span><\/code>
\n\"IF<\/p>\n

 <\/p>\n

STEP 2:<\/span> <\/strong>The IF<\/strong> arguments:<\/p>\n

\n
\n

Table of Contents<\/p>\n<\/span><\/div>\n