This means we need toconcatenatenumbers after we perform the necessary calculations.

The article below explains a basic formula for positive inputs with several variations.

The INT function returns the integer portion of a decimal number and discards any decimal remainder.

Formula adjusted to handle negative inputs

The result from INT is the number of whole feet in B5.

At this point, we have a number for feet and a number for inches.

The inner pair of quotes causes Excel to return one double quote (").

Formula adjusted to handle negative inputs

Finally, all values are concatenated together, and Excel returns a result.

The difference is that we are using theABS functionto convert the input in cell B5 to a positive number.

We do this with theREPT functionat the start of the formula.

Formula adjusted to handle negative inputs

When B5 is not less than zero, the result is FALSE, which evaluates to 0.

The last line concatenates the sign, feet, and inches together and returns the result.

We only need to use the ABS function once.

Formula adjusted to handle negative inputs

This formula will handle positive or negative inputs.

Note that negative numbers becomemore negative.

For example, while INT(10.8) returns 10, INT(-10.8) returns -11.

Formula adjusted to handle negative inputs

MOD Function

The Excel MOD function returns the remainder of two numbers after division.

For example, MOD(10,3) = 1.

The result of MOD carries the same sign as the divisor.

Excel formula: Convert feet and inches to inches

REPT Function

The Excel REPT function repeats characters a given number of times.

For example, =REPT(“x”,5) returns “xxxxx”.

ABS Function

The Excel ABS function returns the absolute value of a number.

Excel formula: Split dimensions into three parts

ABS converts negative numbers to positive numbers, and positive numbers are unaffected.

LET Function

The Excel LET function lets you define named variables in a formula.

Excel formula: Split text string at specific character

Excel INT function

Excel MOD function

Excel REPT function

Excel ABS function

Excel LET function

Article image

Formula adjusted to handle negative inputs