Excel formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to create a formula whereby, if I type in the number 0, the cell
will populate with NO. If I type in the number 1, the cell will populate
with YES.
Is there a way to do this?
 
BJ- thanks for the help! Saved me time.
Here's something to make you chuckle....my son in named BJ!
Deborah
 
You must log in or register to reply here.

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

Similar Threads

formula 6
Excel VBA 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Last Modified By in a cell by user 3
what is the best worksheet function to... 3
Learning arrays. 13
Created invoices in Excel - not working in Drive 1
automatic formula 2

Back
Top