if then formula type

[Julz]

Hello,

I'm having problems with a formula to do the following,

If column M =>0 then subtract column j from column m and give me the
result.


Thanx!!
~Julz

 

[Frank Kabel]

Hi
try
=IF(M1>=0,M1-J1,"")

 

[Julz]

Works like a champ, but it's also giving me M-J when M is blank.
When M is blank then my result should be blank. Make sense?

 

[Frank Kabel]

Hi
one way:
=IF(AND(M1>=0,M1<>""),M1-J1,"")

 

[Julz]

You rock!!

Thanx as always!!

~Julz