What is wrong with this formula?

[ashncg]

--------------------------------------------------------------------------------

=IF(AND(C1="YES",D2=1),(H2-(H2*.3)-95*.07142857),IF(AND(C1="NO",D2=1),(H2-(H2*.3)-70*.07142857),IF=(AND(C1="YES",D2=2),(H2*.85)-95,IF(AND(C1="NO",D2=2),(H2*.7)-70,IF(AND(C1="YES",D2=3),(H2*.6)-70,IF(AND(C1="NO",D2=3),(H2*.6)-95)))))))


I don't know if the format is incorrect, obviously it is, but whether or not it's parenthesis or what, I have no idea. It's driving me crazy. Any help will be greatly appreciated, thanks.

[brokenbiscuits]

--------------------------------------------------------------------------------

=IF(AND(C1="YES",D2=1),(H2-(H2*.3)-95*.07142857),IF(AND(C1="NO",D2=1),(H2-(H2*.3)-70*.07142857),IF=(AND(C1="YES",D2=2),(H2*.85)-95,IF(AND(C1="NO",D2=2),(H2*.7)-70,IF(AND(C1="YES",D2=3),(H2*.6)-70,IF(AND(C1="NO",D2=3),(H2*.6)-95)))))))


I don't know if the format is incorrect, obviously it is, but whether or not it's parenthesis or what, I have no idea. It's driving me crazy. Any help will be greatly appreciated, thanks.

You have a random "=" in the middle of the formula. Plus an extra parenthesis at the end, but Excel would auto-correct that.

[DonkeyOte]

This thread has seen been duplicated and as such does not comply with Rule 5 of our forum rules.

This thread will now be closed, you may continue in your other thread.

Thread Closed.