IF statement macro to use end down for empty cell

[Guest]

How can I construct an if statement to put the results of a calculation in the next empty cell down from any given cell? Doe example, if cell A10 is >+ 1, then put the results in the next empty cell down from cell g23, else null.

 

[Peo Sjoblom]

Functions can't do that, they can only return values where they are. You
would need VBA for that

--

Regards,

Peo Sjoblom

How can I construct an if statement to put the results of a calculation in

the next empty cell down from any given cell? Doe example, if cell A10 is

+ 1, then put the results in the next empty cell down from cell g23, else

null.