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...
 
Top