Findout Plus and Minus Values

[structo]

Dear friends,
What is the macro for finding Plus and Minus Values.

Thanks.

[FoxSeaLady]

Hi

This should not need a macro the following formula in Row 4 will work:-

Col E Row 4=If(MAX(B:B)>0,MAX(B:B),"")
Col F Row 4=If(MIN(B:B)<=0,MIN(B:B),"")

Similarly the same formula in columns H, I except change MAX(B:B) to MAX(C:C)

Cheers

[structo]

Thank you.its good.

[FoxSeaLady]

Hi

Its a pleasue to assist. If you are happy with the solution can you mark your question as solved.

Cheers