can the data be moved to another cell not using any macro?

  • Thread starter Thread starter Mojtaba Ghassemi
  • Start date Start date
M

Mojtaba Ghassemi

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: (e-mail address removed)
 
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","")
 
Back
Top