Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 16th 19, 04:27 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2019
Posts: 2
Default How Do I Remove N/A Error from by formula



  #2   Report Post  
Old July 16th 19, 04:27 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2019
Posts: 2
Default 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)
  #3   Report Post  
Old July 16th 19, 06:06 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2012
Posts: 49
Default 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)


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
REMOVE THE #DIV/0! ERROR FROM FORMULA WHEN FIGURING MULTIPLE AVERA Security Dave Excel Worksheet Functions 5 May 12th 08 04:52 PM
My formula have error, so I remove errors. Feejo Excel Discussion (Misc queries) 2 January 3rd 08 04:31 PM
error: Excel encountered an error and had to remove some formatting to avoid corrupting the workbook; please recheck your formatting carefully Keith Excel Programming 0 January 31st 07 06:38 PM
Error: "Excel encountered an error and had to remove some formatti Carl Excel Discussion (Misc queries) 0 September 18th 06 06:39 PM
remove error value when formula exists for empty cells Cyrus Excel Worksheet Functions 2 February 17th 06 05:19 PM


All times are GMT +1. The time now is 05:28 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017