Simple formula needed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Same answer as yesterday.

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

To see several responses you received yesterday do a search.


Gord Dibben MS Excel MVP
 
I've just got it working thanks!! i've just realised that i'd like to express
the answer in kg..

Gord apologies for repeat posting, i tried searching and couldn't find it.
first time on this forum.
 
No problem.

I see you're using the CDO Interface so I have no idea how to direct you on
search methods and how to find your past postings.


Gord
 
Back
Top