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.
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 (").
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.
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.
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.
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.
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.
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.