cell display the result from the formula

Question

Why can't the cell display the result from the formula. Kindly advise. Thanks.

Answer 1

The problem appears to be that F444 does not contain a number or a text value. It appears to be part of a graphic.

The concatenation operator (&) requires that both left and right operands be text, numbers that can be converted to text, or nul.

Your formula worked fine on my system when I tried all three different values in F44.

Answer 2

Hello,

It is hard to tell based on a screenshot instead of actual data in an Excel file.

Changing the cell format to General will not fix #VALUE!. This error usually means that at least one of the referenced cells, D44, E44, or F44, contains an error or an unsupported value from another formula.

Test each cell separately in blank cells:

=D44

=E44

=F44

Also check them with:

=ISERROR(D44)

=ISERROR(E44)

=ISERROR(F44)

Whichever formula returns TRUE is causing the problem. Correct the underlying formula in that cell first.