Is there equivalent Excel Val2() function in Numbers? I want to get value of a cell, which contains formula. What I need to get the result text from the cell.

The following is example data:

A   B   C
?   0   what?

For example, in cell A1 I have a function like:

=Right(C1)

which is the end character of string in C1. Then I need to use the result of A1 in B1

=Count(C$1:C1, A1 = "?")

As you can see, the result is 0. I think that A1 in above expression is referring to the formula of A1, instead of its result. Is there anything available like this in Numbers?

=Count(C$1:C1, Val2(A1) = "?")