using this statement =EVALUATE(SUBSTITUTE('Field Verification'!J4,"-","*12+")) to create a decimal from a measurement (eight feet two inches and 1/32) written as 8-2+1/32. So if I have two measurements and I subtract one from the other and it give me a negative answer how do I get it to show my negative fraction rather than getting #value! statement.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
negative fraction
- Thread starter jabersold
- Start date
cyrilbrd
Well-known Member
- Joined
- Feb 2, 2012
- Messages
- 4,113
- Office Version
- 365
- Platform
- Windows
- Mobile
Hi, please read this.
Upvote
0
bebo021999
Well-known Member
- Joined
- Jul 14, 2011
- Messages
- 2,553
- Office Version
- 2016
What exactly is in cell J4?
Upvote
0
