![]() 1+TEXT(RIGHT(B2,FIND(",",B2)-1)) will then look to see if there is a comma after the last digit of the telephone number (before the 43121234567). So just to make it more clear, in the above formula I have the current telephone number in B2 and it has a number of commas in it. I have seen the below formula that does a similar job but it doesn't allow a fractional part within the address, I would like to do this without using multiple IF formulas. ![]() ![]() What is the best way to create a quick and easy spreadsheet/formula to work out the sum of any telephone directory number with a fractional section.įor example I have a number that is 43121234567.
0 Comments
Leave a Reply. |