data validation & formulas
Thank you so much!
-----Original Message-----
Hi
Something like this:
=IF(X1="Count",COUNT(A2:A10),IF(X1="Sum",SUM(A2:A 10),IF
(X1="Average",AVERAGE
(A2:A10),"")))
You can define subformulas as named ranges
fCnt=COUNT($A$2:$A$10)
fSum=SUM($A$2:$A$10)
fAvg=AVERAGE($A$2:$A$10)
now you can have the formula
=IF(X1="Count",fCnt,IF(X1="Sum",fSum,IF
(X1="Average",fAvg,"")))
--
Arvi Laanemets
(Don't use my reply address - it's spam-trap)
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
.
|