Checking for Negative Numbers
I'm working on checking for negatives in an Excel sheet. The way information comes to me, it uses {#-} (# representing a number). So when I try to check if it is negative, it believes it is postive.
Ex. -2 = Negative but 2- is Positive.
Because of this issue, I'm trying to create a formula that figures if a cell has a "-" in it, then =LEFT(E22,1)*-1, otherwise, just display the positive value.
What combination would be easier? I'd appreciate any help with this one...
Why not check if the number is less than zero?
=IF(E22<0,"number is negative,"number is positive")
How about
=SIGN(0.5-(ISNUMBER(FIND("-",G4))))*SUBSTITUTE(G4,"-","")
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Thanks Mike! Worked like a charm!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks