Forum Discussion
Solved
Show IFNA Output As Number
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, a...
If you want the result to be a number, don't enclose 101 in quotes:
=IFNA(VLOOKUP($A2; Table2[#All]; 2; FALSE)*1; 101)
=IFNA(VLOOKUP($A2; Table2[#All]; 2; FALSE)*1; "101")
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!