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?

Changing a cells type based on it's value
 

3eith,
Would something along these lines work:

=IF(A1=1,TEXT(A2,"0.00"),TEXT(A3,"0.00%"))

Where A1 is your "scenario"
A2/A3 are formulae/values

HTH

"Keith" wrote:

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?

Changing a cells type based on it's value
 

=IF(A1="scenario 1",500,107%)

"Keith" wrote:

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?