0v3rl0rd
New member
- Joined
- Mar 8, 2015
- Messages
- 4
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Pro Plus 2019
Greetings everyone.
I just registered to pop a (maybe) stupid question.
I've got few simple columns named A, B, C, and D.
Al values are numbers, decimals.
C = A - B >> calculated manually
D = A - B >> using simple formula "=C4-D4"
The problem is that the "check" formula returns "NOPE" opposed to "y" (colored YELLOW).
In the included xlsx file, I tried cleaning up with this formula (I found the suggestion online):
=TRIM(CLEAN(SUBSTITUTE(L5;CHAR(160);" ")))
but, as far as I can see, it only brings more trouble (look at the value after the formula).
Any help appreciated
I just registered to pop a (maybe) stupid question.
I've got few simple columns named A, B, C, and D.
Al values are numbers, decimals.
C = A - B >> calculated manually
D = A - B >> using simple formula "=C4-D4"
Code:
A | B | C=A-B | D=A-B | CHECK IF C=D
| | manual | formula |
995,4 | 957,005 | 38,395 | 38,395 | y
71,88 | 69,504 | 2,376 | 2,376 | NOPE
525 | 10 | 515 | 515 | y
172 | 146 | 26 | 26 | y
190 | 116 | 74 | 74 | y
2630 | 2601,38 | 28,62 | 28,62 | NOPE
33,8 | 31,295 | 2,505 | 2,505 | y
3860 | 3859,456 | 0,544 | 0,544 | NOPE
formula for D:
=C4-D4
formula for CHECK:
=IF(E4=F4;"y";"NOPE")
The problem is that the "check" formula returns "NOPE" opposed to "y" (colored YELLOW).
In the included xlsx file, I tried cleaning up with this formula (I found the suggestion online):
=TRIM(CLEAN(SUBSTITUTE(L5;CHAR(160);" ")))
but, as far as I can see, it only brings more trouble (look at the value after the formula).
Any help appreciated