Thread: Changing a cells type based on it's value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Keith Keith is offline
external usenet poster
  
Posts: 262
Default Changing a cells type based on it's value
I have a sheet that by selecting a scenario from a drop down list some of the
values change. This normally works fine. But this time I have a slight
problem.

In scenario 1 cell B4 will equal 500 but if scenario 2 is selected than B4
needs to equal 107%.

How can I change B4 back and forward from a value to a percentage?

Reply With QuoteReply With Quote