correct my formula

[annadinesh]

dear Experts

I am getting an error on the folllowing formula

Please check and correct it

=IF(I13="Non Add ON",G16*G20,"0"),IF(I13="Add ON - ZD"&J13="Non HIIB Policy",G16*G20,"0")

 

[denzo36]

=IF(I13="Non Add ON",G16*G20,IF(AND(I13="Add ON - ZD",J13="Non HIIB Policy"),G16*G20,"0"))

 

[denzo36]

Actually this is more correct, I presume you want to return the number 0 if your conditions are not met, not the text value of 0 which is "0" in your original formula

=IF(I13="Non Add ON",G16*G20,IF(AND(I13="Add ON - ZD",J13="Non HIIB Policy"),G16*G20,0))

 

[Fluff]

Another option

=IF(OR(I13="Non Add ON",AND(I13="Add ON - ZD",J13="Non HIIB Policy")),G16*G20,0)

 

[annadinesh]

Another option

=IF(OR(I13="Non Add ON",AND(I13="Add ON - ZD",J13="Non HIIB Policy")),G16*G20,0)

Its working fine

can you help me with a modification in formula

=IF(OR(I13="Non Add ON",AND(I13="Add ON - ZD"or"Add ON - ZD+CM",J13="Non HIIB Policy")),G16*G20,0)

 

[Fluff]

How about

=IF(OR(I13="Non Add ON",AND(OR(I13={"Add ON - ZD","Add ON - ZD+CM"}),J13="Non HIIB Policy")),G16*G20,0)

 

[annadinesh]

How about

=IF(OR(I13="Non Add ON",AND(OR(I13={"Add ON - ZD","Add ON - ZD+CM"}),J13="Non HIIB Policy")),G16*G20,0)

THANK A LOT

 

[Fluff]

You're welcome & thanks for the feedback.