i was kindly helped with the forumula

=IF(A1'"YES", B9*B8*0.5,"Not yes")

to the query

I have a questionnaire with drop down menu offering the user a YES or NO
response. I was hoping if the user selects YES that i could get excel to
trigger a simple equation like =B9*B8*0.5

probably simple when you know how.

many thanks

shane

but what if forgot to ask is how can I make "NO" equate to 0(zero) and give
answers in kg???

cheers