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
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
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: 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: 4889) Jul 10, '19 at 9:22 pm