How to execute 2 commands in a cell

[Barcode]

I need to execute 2 commands in N but don't see how I can do that.

The value in K is from another program using DDE and is continually changing.

When M is >= F I want to Move F to N and move zero to K.

I need to zero out K to stop any more processing on this row.

N will be zero while this row is being processed, or equal to F when the processing is finished.

	F	G	H	I	J	K	L	M	N
4	272	Down	Up	10.1 U	27 CU	0.96597	-0.00189	-18.9

<tbody>
</tbody>

Sheet1​

Bob

 

[yaroslav89]

I see it as a two step process. In N4 type =IF($M4>=$F4,$F4,0) and in O4 do a second formula =IF($N1>=0,0,$K1). Once you done this for all rows just copy and paste special values in K column. You can just record a macro for this if you are doing this multiple times. Hope this helps.

<colgroup><col width="64"></colgroup><tbody>
</tbody>

<colgroup><col width="64"></colgroup><tbody>
</tbody>

 

[Barcode]

Thanks very much for the reply.
When I enter the statement in N4 I'm getting a circular reference. Here is the row with formulas:

	F	G	H	I	J	K	L	M	N
4	272	Down	Up	10.1 U	27 CU	0.96509	-0.00101	-10.1

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula K4 ='MT4'|BID!AUDCAD L4 =IF(B4="Sell",D4-K4,K4-D4) M4 =IF(K4>50,L4*100,L4*10000) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[yaroslav89]

Is there a formula in F4 or is it hardcoded number?

 

[Barcode]

F4 is hardcoded

 

[Barcode]

Basically what I want to achieve is to stop processing on the row when M >= F, in this case when M = 272 or greater.


The only way that I see is to clear the formula from K which I haven't been able to do without getting a circular reference error.