Multiple IF formula

[papasmurfuo9]

Hi
please could help with the below multiple IF formula

IF D9 = New and D29 = Yes then D13 * 0.06 + 250
IF D9 = New and D29 = No then D13 * 0.06 + 3500
IF D9 = Existing and D29 = Yes then D13 * 0.06
IF D9 = Existing and D29 = No then D13 * 0.06 + 3500

thanks in advance

[benishiryo]

hi there. maybe:
=D13*0.06+IF(AND(D9="New",D29="Yes"),250,IF(AND(OR(D9={"New","Existing"}),D29="No"),3500,0))

that's assuming you don't have other kinds of combinations. if you do, then:
=IF(AND(D9="New",D29="Yes"),D13*0.06+250,IF(AND(OR(D9={"New","Existing"}),D29="No"),D13*0.06+3500,IF(AND(D9="Existing",D29="Yes"),D13*0.06,"")))

if it doesn't work, upload a sample file & manually key in the results you are expecting to see. you should always do that anyway

[papasmurfuo9]

perfect.
many thanks