hi all,
i'm making a questionnaire/calculator and have added a YES/NO drop down menu.
If the users selects "YES" i'd like excel to execute the following equation
B9*B8*0.5

but haven't been able to work out how to do it. any help would be greatly
received.

shane