£0.00 @

I have a little excel query and need some help. I have 3 cells, say A, B & C (A & B have figures in ie: costs, and C has either Y for Yes or N for No) I need to write a formula, to add together … Read More

I have a little excel query and need some help.

I have 3 cells, say A, B & C (A & B have figures in ie: costs, and C has either Y for Yes or N for No)

I need to write a formula, to add together cells A & B and then C (but this obviously the total will differ if Column C displays Y or N

Can anyone help please me

I have 3 cells, say A, B & C (A & B have figures in ie: costs, and C has either Y for Yes or N for No)

I need to write a formula, to add together cells A & B and then C (but this obviously the total will differ if Column C displays Y or N

Can anyone help please me

Options

## All Comments

(11) Jump to unreadPost a commentadd together cells A & B and then C (but this obviously the total will differ if Column C displays Y or Nthats what I thought

thats what i mean

A = £12

B = £18

C = Y / N (If Y, then I need to add £6, if N then I need to add ZERO)

=IF( A3 != N,"A1+A2")

:thumbsup:

thats what i mean

A = £12

B = £18

C = Y / N (If Y, then I need to add £6, if N then I need to add ZERO)

you answered your own question....

the key word being IF

So you need to put an IF statement in

sorted :thumbsup:

=IF(C1 = "Y",SUM(A1:B1))

Edit.. Oh well too late