IF function



Function Type: Logical

Description:

IF is one of the most popular functions in Excel. It checks if the condition is met then it returns a value. It is used to return one value if the logic is true and another value if false.

Function Structure: 

=IF(logical_test, [value_if_true], [value_if_false])

Argument Breakdown:

logical_test – This is where you put the condition that you want to be checked. In order to specify our logic, we need to use Logical Operators. This argument returns either true or false. E.g. C14 > 5000

value_if_true – This is the value that excel will return when the logical test is true. It can be optional when value if false is present.

value_if_false – Otherwise, this is the value that excel will return when the logical test is false. It can be optional when value if true is present.

Example:

IF

The formula for C2 =IF(B2>=30000,”Approved”,”Declined”)

This means that IF the value in B2 is greater than or equal to 30,000 Excel will return the text “Approved”. IF not, it will return “Declined”.



 

Published by Cash Heaven

Excel Expert and Financial Analyst Excel / Google Sheets / Financial Modelling, Valuation and Analysis Effective communicator / High quality / Affordable / Reliable / Quick Turnover I've successfully completed over 200 financial modelling, valuation and analysis projects with start-up stage and corporate companies over the past 4 years. I love to solve problems, have an eye for design, and have built business excel templates. I fix Excel formulas in 10 minutes.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: