How would i write this

[SQUIDD]

Good evening,

How would add to this.
What i want is if y13 equals 6 or 0 it would equal x13 else nothing.

=IF(Y13=6,X13,"")

I know it is probably simple but it has me stumped.

Thanks

Dave

 

[yytsunamiyy]

=If(OR(X13=6,X13=0);X13;"")

 

[lenze]

=If(OR(Y13={0,6}),X13,"")

lenze

 

[SQUIDD]

Thankyou that worked great.

How about this one

if the sum a1:a6 is more than 0 then = a1&a2&a3&a4&a5&a6 else b1

Thanks

Dave

 

[lenze]

if the sum a1:a6 is more than 0 then = a1&a2&a3&a4&a5&a6 else b1

I don't follow you. Please explain.
lenze

 

[SQUIDD]

sorry i will try again

if the sum a1:a6 is more than 0 then = display the text in these cells a1&a2&a3&a4&a5&a6 else = cell b1.
something like this

=if(sum(a1:a6)>0,a1&a2&a3&a4&a5&a6,b1)

Dave

 

[SQUIDD]

i just tried what i wrote and i think it works, dont know why it dident before.

Dave