multiple If one nested then if overall result

**swieduwi** · 02-25-2007, 02:37 PM

I am having a brain fart, I need some help with a easy IF statment.

I am trying to do this.
in Cell E3 if H3 = A then D3 X 11% and if X3=MD H3 X 11% X 1.09%
if H3 = M then D3 X 15% and if X3=MD H3 X 11% X 1.09%

basicly if H3 = A then multiply D3 by 11% but if H3 = M then D3 multiply by 15% and if X3 = MD multiply D3 by 11% or 15% depending on H3 =A or M
by another 1.09% and put result in E3. does this make sense???

**oldchippy** · 02-25-2007, 04:09 PM

Does this work for you?

=IF(X3="",IF(H3="A",D3*11%,IF(H3="M",D3*15%,"")),IF(AND(X3="MD",H3="A"),IF(AND(X3="MD",H3="A"),D3*11%)+IF(AND(X3="MD",H3="A"),D3*11%)*1.09%,IF(AND(X3="MD",H3="M"),D3*15%)+IF(AND(X3="MD",H3="M"),D3*15%)*1.09%))