adjusting an if, then function in excel

Joined
Oct 31, 2013
Messages
1
Reaction score
0
Hi,
Basically I need a formula that says, if cell A1 is equal to either 1, 4, or 7, put a 1 in this cell, otherwise put a zero.

How can I do this?
I appreciate any help you can offer!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top