Help with nested IF formula

[xx8josh9xx]

First post on here. I tried to look for help on IF AND but I think my specific formula was to complicated for me.


I need help with cell Z15.

My formula is:
IF(F14=1,100, IF(F14=2,50, IF(F14>=5, IF(AND(W3>=3499.99,(I15+J15+K15+L15+O15+P15+Q15+R15+S15+T15+U15+V15+W15+X15)*-0.5,0))))

Im trying to say if W3 is>3999.99 then to do the (I15+J15+K15+L15+O15+P15+Q15+R15+S15+T15+U15+V15+W15+X15)*-0.5,0), but if its not then to output 0,

so if F14=1 (outputs 100) or 2 (out puts 50). If F14 = 5 then to take that row x 50%. only if W3 is above 3499.99 though, if its below 3499.99 then i want it to output 0


Thanks for your help and time to look at this.