Simple formula needed
 

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

Simple formula needed
 

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

Simple formula needed
 

If cell A1 holds the YES/NO, then:
=IF(A1="YES",B8*B9*0.5,"")
--
Gary''s Student - gsnu200750

Simple formula needed
 

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


On Thu, 18 Oct 2007 09:16:00 -0700, shane
wrote:

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

Simple formula needed
 

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.

Simple formula needed
 

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

On Thu, 18 Oct 2007 09:43:02 -0700, shane
wrote:

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.