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

# if statement

0

## Answers

0

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.

- Let [Net Come] = SUM(B5:F5)
- Let "increase the Adjusted Net Income by 12.9%" be a mistake. Instead, assume that [Adjusted Net Income] = "Net Income" + 12.9%
- 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])
or
= [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))
or
= SUM(B5:F5) + IF(SUM(B5:F5) > 680, SUM(B5:F5) * 12.9%, 0)
```

### Discussion

Almost looks like some sort of a test from a training session. Not that I have ever had any training.

k1w1sm (rep: 177) 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: 3063) Jul 10, '19 at 9:22 pm