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: