how can I select two different values for a cell?
 

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?

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?