Text to equation??

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

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