IF statement to get a return value that adds up values from two cells?

Hello. I have three columns on my data:
COlumn A: consist of text of "Nice" or "Bad"
Column B: all numeric
Column C: all numeric

I want the IF statement to do this:

=IF(Column A="Bad", SUM the values in Column B and C or else give me value in Column C)

Does it make sense?

So my True statement needs to give me the SUM of the value in Column B and C, if it meets the statement...

Can anyone help? Thank you!!!!

Try

=C2+B2*(A2="Bad")

I just tried...it doesn't work when A2 does not equal to Bad, when A2 doesnt even to Bad i do not need those two columns to be sum i just need value from Column C.
so i was writing this: =IF(A2="Bad", SUM of B2+C2, C2)

I think i am almost there....i just need someone to fix the SUM piece...

please help!!

I just fixed it and now it is working...So for my own knowledge, is this not a typical IF statement? What does it call? what does the * in the statement actually do here?

Thank you very much!!

* = multiplication
2*4 is saying (2 multiplied by 4)

You didn't really need an IF in this case, based on the assumption of only 2 possible values in the cell (Nice or Bad)
So we only need a True or False based on the test if the cell = BAD
If the Cell DOES = Bad, then it's true.
If the cell Does NOT = Bad, then we can assume it must equal Nice.

And you wanted C to be included in the sum regardless if A is Bad or Nice.
Only B is inclucded or excluded based on if A is Bad or Nice.


Hope that helps.