If a cell has a certain reference it will add 2 other columns or subtract them

[preddy1110]

is there a formula for: If column A has a "Y" it will add columns B&C. If column A has a "N" it will subtract columns B&C? I thought about SUMIF, but can't seem to get it to work.

Col A
Y
N

Col B
10
5

Col C
5
10

[zbor]

Maybe this:

=B1+IF(A1="Y", 1, -1)*C1

Of course, this formula don't care if you put N or anything else.. Just look is it Y.