Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Formula Using Select Values of a Cell | Excel Worksheet Functions | |||
Using a formula to select a cell using the row and column values | Excel Worksheet Functions | |||
select date range then find average of values in another cell | Excel Worksheet Functions | |||
how can I select two different values for a cell? | Excel Worksheet Functions | |||
using cell values to select range of cells | Excel Programming |