View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
KL KL is offline
external usenet poster
 
Posts: 201
Default how can I select two different values for a cell?

Hi,

Have you considered using Comment as storage for the second value?

Another way might be introducing the following formula into the cell and
changing the A1 depending onthe value you want to see:

=INDEX({Value1,Value2},$A$1)

Regards,
KL

"Parastoo Parto" <Parastoo wrote in message
...
I have a sheet with one column I would like to give it two values. In fact
I
would like the column show me the ACTUAL value or the FORECAST value
anytime
I want .I don't like to make 2 columns and fill one column with actual
data
and the other with forecast data.How can I do that?