Forum Discussion
Multiplying with few conditions
Hi.
I need a help with some calculations where few conditions have to be met.
First is that values in column B have to meet values in column D. Then if so, the value in column B multiplies with t...
Detlef's solution using sumproduct is an elegant solution and one I would usually use ... but it doesn't tell you why you were not having success with the IF statement approach you were taking. Try this ...
=IF(AND(B3>=D3,E11>=H10),B3*H3,
IF(AND(B3>=D3,E11>=G10),B3*G3,
IF(AND(B3>=D3,E11>=F10),B3*F3,B3*E3
)))
You were pretty much there but didn't get the AND syntax quite right.