=IF(A1="YES", B9*B8*0.5,IF(A1="NO",0,"Not yes or no"))


--
---
HTH

Bob

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



"shane" wrote in message
...
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