Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Monday, 26 November 2018
  2 Replies
  8.9K Visits
0
Votes
Undo
I am trying to strip the first digit "if " the sum of two digits is a double digit. If there is a single digit I want the result to remain untouched.

Example : if I add the sum of 9 and 3 in the cells the normal result will be 12.
The desired outcome I am trying to formulate is the result will leave 2 instead of 12.

However I need a variable if the result of two cells is a single digit, lets sat we change the sum instead of 9, is 5 plus 3, which equals 8. Then the 8 is left unaltered.


It is a simple numerical text input and output, how ever the additional variable to strip the 1st digit "if 2 exist and replacement is not a mathematical formula.


Thank you in advance for looking at this problem I cannot seem to correctly formulate

Jerr
5 years ago
·
#1785
0
Votes
Undo
Hello,
Sorry, we don't have it yet. :)
We may try to add it in the upcoming versions.
5 years ago
·
#1786
0
Votes
Undo
Hello,

You can use this formula:

=IF(INT(SUM(A1,B1))>9, MOD(INT(SUM(A1,B1)),10),INT(SUM(A1,B1)))
  • Page :
  • 1
There are no replies made for this post yet.