In an adjacent cell enter this

=IF(cellref="YES",B9*B8*0.5,"NO selected, what now?")

Where cellref is the cell with the dropdown


Gord Dibben MS Excel MVP


On Wed, 17 Oct 2007 11:00:00 -0700, shane
wrote:

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