#VALUE! error using excel 2016 nested IF statements

Question

I'm unable to perform a simple nested IF statement on this data, the conditional seems perfect to me so it must be a formatting error or something else. I'm new to excel so I could be wrong.

This is the conditional.

Answer 1

I think you have one too many parentheses after the (1+E4) piece. I'm far from proficient with Excel formulas but I was tinkering a bit and that seemed to fix it for me.

Barring that I also thought it was odd that you have semicolons to separate each term in the IF statement. I've always used commas.