How do you find the first IF Function and Second IF Function on Excel. What is t

Question

How do you find the first IF Function and Second IF Function on Excel. What is the formula used?

2012 2013 2014 2015 Sales Commissions: Sales in Units Unit Sales Price 1500 1200 2250 1200 4100 1200 1800 1200 Commission % less than first Break point Commission % less than 2nd Break point Commission over 2nd Break point 5% 8% 11% 5% 3% 11% 5% 8% 11% 5% 3% 11% First Break Point in Units Second Break Point in Units 2,000 4,000 2,000 4,000 2,000 4,000 2,000 4,000 First IF Function Total Sales Commissions 108,000 168,000 349,200 129,600 Second IF Function Total Sales Comissions 96,000 168,000 349,200 124,800

Explanation / Answer

The Microsoft Excel IF function returns one value if the condition is TRUE, or another value if the condition is FALSE.

The IF function is a built-in function in Excel that is categorized as a Logical Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the IF function can be entered as part of a formula in a cell of a worksheet.

Please read our IF-THEN-ELSE (VBA) page if you are looking for the VBA version of the IF statement as it has a very different syntax.

TIP: If you have Excel 2016, try the new IFS function (and specify up to 127 conditions).

Syntax

The syntax for the IF function in Microsoft Excel is:

Parameters or Arguments

Returns

The IF function returns value_if_true when the condition is TRUE.
The IF function returns value_if_false when the condition is FALSE.

Applies To

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.