Excel Help: Urgent - HotUKDeals
Get the HotUKDeals app free at Google Play

#### Search Error

An error occurred when searching, please try again!

# Excel Help: Urgent

£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
7y, 2m agoPosted 7 years, 2 months ago
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

7y, 2m agoPosted 7 years, 2 months ago
Options

(11)
#1
You really need to do an excel training course :whistling:
banned#2
makes no sense whatsoever to me

add together cells A & B and then C (but this obviously the total will differ if Column C displays Y or N
#3
I dont quite get you....if A & B have values in them and C just has a Y or a N...then how can you add the 3 together?
#4
You have to use an if statement I think, check if C is yes, then add some value, else, add some other value. How you do it in excel I don't know. Might be helpful http://www.free-training-tutorial.com/if-statement.html
#5
InfernoZeus
You have to use an if statement I think, check if C is yes, then add some value, else, add some other value. How you do it in excel I don't know. Might be helpful http://www.free-training-tutorial.com/if-statement.html

thats what I thought

Abz
I dont quite get you....if A & B have values in them and C just has a Y or a N...then how can you add the 3 together?

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)
#6
Wow excel it's been a while, i'm presuming you can still use vb.net so could you not do something like

=IF( A3 != N,"A1+A2")
#7
=A+B+if(C="Y",6,0)
banned#8
chri1143;8532246
=A+B+if(C="Y",6,0)

:thumbsup:
#9
Disco
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)

the key word being IF

So you need to put an IF statement in
#10
chri1143
=A+B+if(C="Y",6,0)

sorted :thumbsup:
#11
Got it:-D

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

Edit.. Oh well too late