Unable to combine two statements

[Kmitchell]

I am having some trouble merging the two statements below. They work fine independently but when I add them together I get an error message. Basically there are 4 components, if X=0,0, if >245K, if less than $106.8K and if between $106.8k and $245K. Any suggestions?


IF(X8=0,0,IF(E8>245000,106800*0.057+(245000-106800)*0.114,IF(E8<106800,E8*0.057,106800*0.057+(245000-E8)*0.114)))

IF(AND(E8<245000,E8>106800),106800*0.057+(E8-106800)*0.114)

 

[brans1982]

Hi,

It's becasue you first formula already had a false statement at the end, thus ending the formula.

IF(X8=0,0,IF(E8>245000,106800*0.057+(245000-106800)*0.114,IF(E8<106800,E8*0.057,106800*0.057+(245000-E8)*0.114)))

Try this....

=IF(X8=0,0,IF(E8>245000,106800*0.057+(245000-106800)*0.114,IF(AND(E8<245000,E8>106800),106800*0.057+(E8-106800)*0.114,IF(E8<106800,E8*0.057,106800*0.057+(245000-E8)*0.114))))

 

[Kmitchell]

Oh thank you so much!