I am trying to get a value rather than a true or false answer. Cell DJ,2 has this formula

= if DI,2 is > 0 (put value of) DI,2 in Dk,2Or is there another way to achieve this?

message edited by Basecalc

A formula can only return a result into the cell in which it resides. In other words, a formula in DJ2

can notplace a result in DK2. The formula in DJ2 can only place its result in DJ2.The only way for a result to end up in DK2 is either via a formula that resides in DK2 or by using a macro that monitors DJ2 and then writes something into DK2 based on what it sees in DJ2.

Why can't you just put the formula in DK2?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03

Thank You again DD03 for your assistance,

BC

If the formula is in DK2 it will move with inserting column (not wanted)

Then shouldn't you have posted that method for doing the macro?

You now have at least three threads asking about the same issue. In addition, you are responding in this thread to a comment made in a different thread. If you have a comment or followup question, please post it in the relevant thread so that members can follow the conversation in a logical manner.

Thank you for your understanding.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Do you think Microsoft can save the Surface Book lineup?

Discuss in The Lounge

Poll History