data validation & formulas
Thank you so much!
-----Original Message-----
Hi
try
=IF(D6="Cat",A1+B1,IF(D6="Dog",A1*B1,IF(D6="Eleph ant",A1-
B1,"")))
where cat, dog & elephant are the three options you have
in your drop down
list in cell D6
Cheers
JulieD
wrote in message
...
Hello great folks who have saved me more than once:
I have a data validation list (drop down list) in one
cell, which offers a choice of 3 different selections;
in
the next cell I have a formula (would like to have a
formula for each validation). Is it possible to create
a
formula that says if this is chosen in the data
validation
box, use this formula, if something else is chosen from
the drop down box use another formula, etc? Thus, a
different formula for each choice in the validation
list.
Thank you in advance
.
|