Changing cell value depending on dropdown list

  • Thread starter Thread starter RogerDaShrubber
  • Start date Start date
R

RogerDaShrubber

I am currently working on a worksheet that has a dropdown list with the
following values in cell B3

Structured Walkthrough
Formal Inspection
Passaround Review

If Structured or Passaround is selected I would like cell B38 to
display "N/A"

But if it is Formal Inspection I would like a formula to be inserted
into cell B38
"=b11(b7/b6)"

I know this is probobly simple, I have not used VB in conjuction with
Excel before.

Thank you in advance for your help.
Larry
 
in B38

=if(or(B3="Structured Walkthrough",B3="Passaround
Review"),"N/A",B11*(B7/B6))

I added an "*", but that may not be correct for the formula - but what you
posted certainly isn't correct.
 
Back
Top