Tuesday 19 January 2016

Simple way to check Negative or Positive Number

=IF(SIGN(A1) = -1,"Negative","Positive")


OR


=IF(LEFT(A1,1)="-","Negative","Positive")

No comments:

Post a Comment