Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Write data from one cell to another cell
Write data from one cell to another cell
Is there any way to SEND data from one cell to another? I wish to use a nested IF function in one cell to choose between three different criteria, in the event 1 then output A, event 2 then output B, Etc. However I want the three different outputs to go to three different cells. Is there any way that I can write the result of a formula in one cell to appear in another (say the formula is in cell A1, but I want the output to appear in either B1, B2 or B3 depending upon the output of the formula). I know that this could be done by using a second IF function in each of the €˜receiving cells (i.e. B1..B3) but I am looking for a solution where I can leave the cells B1..B3 blank and only have data appear in them after cell A1 has performed its function. Comments: I am looking for a solution that does not require the use of either VBA or macros. I am using Excel 2007. Also please include any relevant information about cell formating Etc. Many thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Entry - Write to next cell | Excel Discussion (Misc queries) | |||
Data Entry - Write to next cell & next blank line | Excel Worksheet Functions | |||
Can I write an infinite amount in a cell with expanding the cell? | Excel Discussion (Misc queries) | |||
How to write for copying a cell value to another cell | Excel Worksheet Functions | |||
How do you write an excel formula to sum data in every second cell | Excel Worksheet Functions |