how to move data from a cell to another one without using any macr

  • Thread starter Mojtaba Ghassemi
  • Start date
M

Mojtaba Ghassemi

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 (e-mail address removed)
 
R

Roger Govier

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.
 
D

Don Guillett

in the "other" cell
=if(originalcell="x",1,2)
or
=if(originalcell<>25,1,2)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

can the data be moved to another cell not using any macro? 1
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Compressing multiple functions across an array into one cell 6
Can UDF return a customized hyperlink? 3
Filtering data 2
Write data from one cell to another cell 0
Write data from one cell to another cell 1
How to Find Data in another Worksheet without activating it? 2

Top