Groups

# Excel Help: Urgent

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

Banned

add together cells A & B and then C (but this obviously the total will differ if Column C displays Y or NOriginal Poster

thats 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")

Banned

:thumbsup:

you answered your own question....

the key word being IF

So you need to put an IF statement in

Original Poster

sorted :thumbsup:

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

Edit.. Oh well too late