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: |
All times are GMT +1. The time now is 08:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com