Nested if statements that's killing me

[gigimarga]

I have a column for base cost (dollars).

A second column has values of "Yes" or "No", where "Yes" has a value of $3 and "No" has no value.

A third column has values of "Yes" or "No" , where "Yes" has a value of $2 and "No" has no value.

In the fourth column I have to calculate the total cost based on columns 1, 2, and 3.

So for record 1 I have $18 (cost), followed by a "Yes" (which is $3), followed by a "No". In this case the Total Cost is $21.

Please help!

 

[ribojessi]

I don't think you need to use nested If's. If I'm reading this right, it would be simpler to do something like this:

=IF(B2="yes",3,0)+IF(C2="yes",2,0)+A2

Does that work?

 

[AkaTrouble]

in column D try

=A1+(IF(B1="yes",3,0)+(IF(C1="yes",2,0)))

 

[gigimarga]

It does!

Thank you!!