Thread
:
how can I select two different values for a cell?
View Single Post
#
2
Posted to microsoft.public.excel.programming
KL
external usenet poster
Posts: 201
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?
Reply With Quote
KL
View Public Profile
Find all posts by KL