SOLVED

Show IFNA Output As Number

Copper Contributor

Hi,

 

I would like to show "101" with a IFNA formula. This works great. But the problem is, that the outputted number (101) is now shown as a number, and can thereby not be used in a pivot table, as I would use. Is there a way, that you can force the IFNA output to be a number - or is there another work around?

 

Thanks in advance.

4 Replies

@TobiasHyldeborg 

What is the formula you are using?

=IFNA(VLOOKUP($A2; Table2[#All]; 2; FALSE)*1; "101")
best response confirmed by TobiasHyldeborg (Copper Contributor)
Solution

@TobiasHyldeborg 

If you want the result to be a number, don't enclose 101 in quotes:

 

=IFNA(VLOOKUP($A2; Table2[#All]; 2; FALSE)*1; 101)

Nice, thank you!
1 best response

Accepted Solutions
best response confirmed by TobiasHyldeborg (Copper Contributor)
Solution

@TobiasHyldeborg 

If you want the result to be a number, don't enclose 101 in quotes:

 

=IFNA(VLOOKUP($A2; Table2[#All]; 2; FALSE)*1; 101)

View solution in original post