Forum Discussion
Solved
Subtraction Help
I'm looking for a formula to return certain values when using excel. For instance: Cell A1 would be 531 Cell B2 would be 185 I want to subtract but I want it to return 454 as the answer. So it wo...
If you're certain the two numbers have the same number of digits, a slightly shorter version:
=CONCAT(ABS(MID(A1,SEQUENCE(LEN(A1)),1)-MID(B2,SEQUENCE(LEN(A1)),1)))
If you're certain the two numbers have the same number of digits, a slightly shorter version:
=CONCAT(ABS(MID(A1,SEQUENCE(LEN(A1)),1)-MID(B2,SEQUENCE(LEN(A1)),1)))
HansVogelaar this worked perfectly. It will always be a three digit number. Thank you so much.
With double dash in front...
OK, yes!
