Text to equation??

[Guest]

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

 

[David Biddulph]

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,"")

 

[Gord Dibben]

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

 

[JW]

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,"")