Macro to show cell result

[Juan C]

Hello all...

I have the following problem :

I need a macro that displays on cell D3 the result of cell B3, every time cell B3 changes from 0 to a non 0 number.
To clarify: if cell B3 changes from 0 to xxx, then cell D3 will show xxx and remains with the same result unless cell B3 goes back to 0. Then when cell B3 changes again from 0 to yyy, then D3 will show yyy.

Could somebody help me with this macro?

Thanks

JC

 

[Jonmo1]

You don't need a macro for that...
Try a formula in D3

=IF(B3=0,"",B3)


Hope that helps.

 

[Juan C]

Thanks Jonmo1

Your formula won't work, because if B3 changes the result lets say, from 4 to 5, then it will display 5. The macro must only show the first value after B3 changes from 0 to a value.

Thanks....

JC

 

[Jonmo1]

Ahh, OK

Will only numbers be entered in B3?
Or is it actually necessary to test the new value to be a number?

 

[Juan C]

Nope.... cell B3 contain a formula that will display numbers....

Thanks

JC

 

[CharlesChuckieCharles]

Try

=IF(B2=0,"",IF(AND(B2<>0,D1<>""),D1,B2))

 

[Jonmo1]

OK, we're going to need to trace the formula in B3 back to the cells that cause it's value to change...

What is the formula in B3..


Basically, which cells cause the result of the formula in B3 to change?

 

[Juan C]

Charles...

What is cell D1 for?

Thanks

JC

 

[CharlesChuckieCharles]

the value of the result in the cell above to know whether you have changed values from a previous blank (zero in B) or not then use the previously value that changed until b=0

if it's not working maybe you should post an example of your spreadsheet

 

[Juan C]

Jomno1

B3= A15...

A15= (external link) * if(B1>Time(),1,0)

Thanks

JC