if statement


If Net Income is greater than 680 increase the Adjusted Net Income by 12.9% else use the Original Net Income you answer should be in range B5:F5




You would look for a formula like this one.

= IF([Net Income] > 680, [Adjusted Income] + 12.9%, [Net Income])

That is very easy to calculate but your question doesn't provide the value of either [Net Income] or [Adjusted Net Income]. So, let me guess.

  1. Let [Net Come] = SUM(B5:F5)
  2. Let "increase the Adjusted Net Income by 12.9%" be a mistake. Instead, assume that [Adjusted Net Income] =  "Net Income" + 12.9%
  3. For good measure, let me assume that [Original Net Income] = [Net Income]

Based on the above assumptions you have two ways of resolving the logic.

= IF([Net Income] > 680, [Net Income] + 12.9%, [Net Income])
= [Net Income]  + IF([Net Income] > 680, 12.9%, 0)

Both formulas return the same result. You can choose the logic which better appeals to you. Below are the two expressions converted to Excel formulas.

= IF(SUM(B5:F5) > 680, SUM(B5:F5) * 112.9%, SUM(B5:F5))
= SUM(B5:F5)  + IF(SUM(B5:F5) > 680, SUM(B5:F5) * 12.9%, 0)


Almost looks like some sort of a test from a training session. Not that I have ever had any training.
k1w1sm (rep: 197) Jul 10, '19 at 4:52 pm
I thought so, too. That's why I went to some length to explain the method by which to convert a logic expressed in plain language into a standard Excel formula.
Variatus (rep: 3368) Jul 10, '19 at 9:22 pm
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login