Combing IF and SIGN

[123rickfear]

Hi,

I am using the sign formula in column N. I only want to show the arrows if J2 does not =0.

I have tired amending my formula from =SIGN(M3-D3) to =if(J2<>"0",SIGN(M3-D3),"") but the arrows are still showing.

Anyone with any ideas?

 

[FormR]

=if(J2<>"0",SIGN(M3-D3),"")

Hi, no idea what arrows you are referring to but try removing the red double quotes indicated above from around the zero.

 

[123rickfear]

that worked, thanks.

Sorry the arrows are the conditional format icons I added.