Text to equation??
 

hi all,
i'm making a questionnaire/calculator and have added a YES/NO drop down menu.
If the users selects "YES" i'd like excel to execute the following equation
B9*B8*0.5

but haven't been able to work out how to do it. any help would be greatly
received.

shane

Text to equation??
 

If your YES/NO is in B10, then your formula would be
=IF(B10="YES",B9*B8*0.5,"whatever you want if the answer isn't YES")
If you want the result to be blank if B10 is not YES, then
=IF(B10="YES",B9*B8*0.5,"")
--
David Biddulph

"shane" wrote in message
...
hi all,
i'm making a questionnaire/calculator and have added a YES/NO drop down
menu.
If the users selects "YES" i'd like excel to execute the following
equation
B9*B8*0.5

but haven't been able to work out how to do it. any help would be greatly
received.

shane

Text to equation??
 

In an adjacent cell enter this

=IF(cellref="YES",B9*B8*0.5,"NO selected, what now?")

Where cellref is the cell with the dropdown


Gord Dibben MS Excel MVP


On Wed, 17 Oct 2007 11:00:00 -0700, shane
wrote:

hi all,
i'm making a questionnaire/calculator and have added a YES/NO drop down menu.
If the users selects "YES" i'd like excel to execute the following equation
B9*B8*0.5

but haven't been able to work out how to do it. any help would be greatly
received.

shane

Text to equation??
 

In the cell where you want this calculation performed, place something
like this (assuming that your Yes/No field is in column A):
=IF(A8="Yes",B9*B8*0.5,"")

shane wrote:
hi all,
i'm making a questionnaire/calculator and have added a YES/NO drop down menu.
If the users selects "YES" i'd like excel to execute the following equation
B9*B8*0.5

but haven't been able to work out how to do it. any help would be greatly
received.

shane