Simple formula needed

[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

 

[Guest]

i read a post on different subject and just tried =IF(C46>YES,"B9*B8*0.5")
to no avail...

 

[Guest]

If cell A1 holds the YES/NO, then:
=IF(A1="YES",B8*B9*0.5,"")

 

[Gord Dibben]

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

 

[Guest]

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.

 

[Gord Dibben]

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