| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to move data from a cell to another one without using any macr
i used If Function to set a criterion for Excel to perform a task if the
returned value is TRUE. of course it did it. now I'd like to know how i can show the results in another cell if the returned value of If Function is FALSE. It can be done by defining a Macro but I like not to use any macro. does anyone by chance know how it can be done!? if so you can send your helpful reply to my email address or post it here! my email is |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to move data from a cell to another one without using any macr
Hi
A function can only return a value to the cell in which the function is located. It cannot "push" a result to another cell. -- Regards Roger Govier "Mojtaba Ghassemi" wrote in message ... i used If Function to set a criterion for Excel to perform a task if the returned value is TRUE. of course it did it. now I'd like to know how i can show the results in another cell if the returned value of If Function is FALSE. It can be done by defining a Macro but I like not to use any macro. does anyone by chance know how it can be done!? if so you can send your helpful reply to my email address or post it here! my email is |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to move data from a cell to another one without using any macr
in the "other" cell
=if(originalcell="x",1,2) or =if(originalcell<25,1,2) -- Don Guillett Microsoft MVP Excel SalesAid Software "Mojtaba Ghassemi" wrote in message ... i used If Function to set a criterion for Excel to perform a task if the returned value is TRUE. of course it did it. now I'd like to know how i can show the results in another cell if the returned value of If Function is FALSE. It can be done by defining a Macro but I like not to use any macro. does anyone by chance know how it can be done!? if so you can send your helpful reply to my email address or post it here! my email is |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Move cell data to another worksheet cell automatically. | New Users to Excel | |||
| Copy data from one worksheet to another using a function or a macr | Excel Worksheet Functions | |||
| How do I convince the cursor to select a given cell when in a macr | Excel Discussion (Misc queries) | |||
| enter data in cell which will start macro to move data to sheet2 | Excel Discussion (Misc queries) | |||
| How do I move data from one cell and add to another? | Excel Worksheet Functions | |||
![Mojtaba Ghassemi[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
