ExcelBanter - How Do I Remove N/A Error from by formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How Do I Remove N/A Error from by formula (https://www.excelbanter.com/excel-worksheet-functions/454368-how-do-i-remove-n-error-formula.html)

[email protected]

How Do I Remove N/A Error from by formula

[email protected]

How Do I Remove N/A Error from by formula

On Monday, July 15, 2019 at 11:27:05 PM UTC-4, wrote:

=RANK(B2,B$2:B$15,0)

MyVeryOwnSelf[_3_]

How Do I Remove N/A Error from by formula

=RANK(B2,B$2:B$15,0)

My guess is that B2 doesn't contain an Excel number value, but instead contains an Excel text value that looks like a number.

One way to fix this is by wrapping it this way in B2:
=--(Whatever_is_in_B2_now)

All times are GMT +1. The time now is 05:29 AM.