Changing cell value depending on dropdown list
 

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


---
Message posted from http://www.ExcelForum.com/

Changing cell value depending on dropdown list
 

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.

--
Regards,
Tom Ogilvy

"RogerDaShrubber " wrote in
message ...
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


---
Message posted from http://www.ExcelForum.com/

Changing cell value depending on dropdown list
 

Thank you so much. That got me where I needed to go.


---
Message posted from http://www.ExcelForum.com/