Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can the data be moved to another cell not using any macro?
using If Function, i set a criterion for excel to perform a task and show the
result in a cell. now i want it to show the result in another cell if the logic value set in IF Function returns FALSE. Of course, it is possible by defining a MACRO. but I'd like not to use any macro to do that. Is there anyone by chance know whether or not it can be done in excel!!? thanks in advance. you can post your kind answers either to this group or to my email. here is my email: |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can the data be moved to another cell not using any macro?
Hi
A formula can only return a value to the cell in which it is placed. It cannot return a value to another location. You could have in cell A10 =IF(SUM(A1:A9)100,SUM(A1:A9),"") then in cell C10 =IF(A10="","Some text","") "Mojtaba Ghassemi" <Mojtaba wrote in message ... using If Function, i set a criterion for excel to perform a task and show the result in a cell. now i want it to show the result in another cell if the logic value set in IF Function returns FALSE. Of course, it is possible by defining a MACRO. but I'd like not to use any macro to do that. Is there anyone by chance know whether or not it can be done in excel!!? thanks in advance. you can post your kind answers either to this group or to my email. here is my email: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I moved a file from work to home and now my color macro does not w | Excel Worksheet Functions | |||
Right justify moved data only part way | Setting up and Configuration of Excel | |||
Right justify moved data only part way | New Users to Excel | |||
Macro Error when moved Xcel Sheets from User's Home Dir to Networ | New Users to Excel | |||
how do I keep a macro with spreadsheet when moved | Excel Discussion (Misc queries) |