# How would i write this

#### SQUIDD

##### Well-known Member
Good evening,

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

### Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
=If(OR(X13=6,X13=0);X13;"")

Code:
``=If(OR(Y13={0,6}),X13,"")``
lenze

Thankyou that worked great.

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

Thanks

Dave

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

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

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

Dave

Replies
3
Views
187
Replies
5
Views
210
Replies
0
Views
223
Replies
2
Views
150
Replies
4
Views
196

1,196,073
Messages
6,013,265
Members
441,758
Latest member
Abren

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back