Changing a cells type based on it's value

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

Guest

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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Peculiar default cell format 1
Formula based on text value.. 3
Enter data into a cell that already has a function. 2
vlookup MAYBE??? 3
want to track time while paste value in multiple column of same roe 1
Function help requested please 6
which function can get the desired result? 3
result of formula posted in different cell 2

Back
Top