Ramneek Sharma - VB From Technical View
MCTS, MCPD, MCT, IBM SQA,Green Belt Six Sigma.
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment