Allowed values in a cell/column range

  • Thread starter Thread starter Ariel
  • Start date Start date
A

Ariel

Im not sure if this can be done. I figured out the first
part already. It's the second part Im having some trougle
with.

Lets say a have a column that I only want a specific
entry: (y, n or n/a). I got that part figured out.

Now lets say that if a "y" is entered in that cell/column
it will produce a number value in another cell/column. For
arguments sake the number 1. But if a "n" or "n/a" is
entered in the same cell/column the value produced in the
other column/cell would be 0.

Can it be done?
 

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

sum values 6
Index and match across columns 5
operating over a range in an array 1
Count with multiple column criteria 2
Please help on formula that will not work (If-And formula) 3
Validate entry based on another cell value 6
If Formula to Identify Cell 1
Sort of like SUMIF and COUNTIF - but return a conditional value 2

Back
Top