List Box Setup

[Guest]

I am admittedly a novice at Excel so this may be an easy one. I am trying to
setup a Yes/No question which will trigger the use of different formulas on a
different sheet within the same workbook. I assume that doing a list box is
the simplest means of accomplishing this goal, but I am having trouble
getting this setup. My questions are:

1) Is a list box the easiest way to set this up?
2) Where do I assign the Yes/No names to the different options?
3) Where do I put the formula assigned to each response?

Thanks for any help in advance!

Shawn

 

[Bob Phillips]

Data Validation is the simplest way.

Data>data validation, choose List, and put Yes,No in the List.

and then in the formulae use

=IF(DV_cell="No","",formula)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)