Nested IF?

[Qazxswe]

I have a series of prices as; D4 = Item A, D5 = Item B D6 = Item C

I have a IF statement in J15 which reads =IF(H15="YES",$D$4+D$6$,0) so adding Item A + Item C

In I15, if this contains a "Yes", I want the above statement in J15 to add together all three items (so D4+D5+D6)

What is the best way to do this? I am trying to do a nested IF but it stops after the initial statement so just adding items A + C

 

[Qazxswe]

That still doesn't make it any clearer.

What is the correct result for "Yes" in both cells?

Sorry.

"Yes" in both cells should result in item A + B + C

"Yes" in H15 and <blank> in I15 should be A+C

<blank> in H15 and "Yes" in I15 should be item B

<blank> in both cells should be zero

 

[jasonb75]

In that case try

=IF(H15="Yes",D4+D6)+IF(I15="Yes",D5)

For future reference, it is better to use "" to indicate an empty cell, otherwise it looks like there is something missing from your description.

 

[Qazxswe]

Thanks again - appreciate the help - works a treat