Linking Data into Cells

D

Don

Hi Jon,

As Patti suggests, a nested "IF" formula will do fine,
however, if you have quite a few possible entries, you
might want to consider a drop-down list box for your
entries, as any error in typing will make the "IF" formula
fail.

HTH,

Don
 
P

Patti

Ah! Good point!
-----Original Message-----
Hi Jon,

As Patti suggests, a nested "IF" formula will do fine,
however, if you have quite a few possible entries, you
might want to consider a drop-down list box for your
entries, as any error in typing will make the "IF" formula would
like to find a way
.
Click to expand...
 

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

Copy corresponding cell in Column B if cell in A contains certain text? 1
VLOOKUP & Data Validation 0
Creating Multi Level list using Header Style 1
IF statement based on True/False that activates a certain list box 1
MS excell 2007 Data verification list 1
How do I create a drop down box within a drop down box? 1
Concatenate cells with line breaks in them 4
Maxing out nesting levels limitation of IF function 3

Top