Display a "blank cell" if the number is negative using an "If Function".

[GeorgeCunn]

If cell A1=2 then I want to subtract B2-B1 and if the number is a negative value, Display a blank cell. I'm a novice and can't figure how to do this.

Thank you.

 

[Fluff]

maybe
=IF(A1=2,IF(B2< b1,"",b2-b1),"")

 

[jondavis1987]

=if(and(a1=2,(b2-b1)>=0),b2-b1,"")

 

[GeorgeCunn]

=if(and(a1=2,(b2-b1)>=0),b2-b1,"")

Thank you very much. This solved my problem.