How to use If statement nested with Offset to return Value

February 18, 2016 at 07:25:34
Specs: Windows 7
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,2

Or is there another way to achieve this?

message edited by Basecalc


See More: How to use If statement nested with Offset to return Value

Report •


#1
February 18, 2016 at 08:04:45
A formula can only return a result into the cell in which it resides.

In other words, a formula in DJ2 can not place 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


Report •

#2
February 18, 2016 at 09:17:35
Thank You again DD03 for your assistance,
BC

Report •

#3
February 26, 2016 at 20:47:04
If the formula is in DK2 it will move with inserting column (not wanted)

Report •

Related Solutions

#4
February 26, 2016 at 21:14:49
Then shouldn't you have posted that method for doing the macro?

Report •

#5
February 27, 2016 at 06:43:46
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.


Report •


Ask Question