Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 19th 05, 10:33 PM
vmagal1
 
Posts: n/a
Default MODE FORMULA ERROR

When I try to use the mode function on a set of values, I get #N/A back as my
answer. Please help!


  #2   Report Post  
Old May 19th 05, 11:24 PM
Pat Flynn
 
Posts: n/a
Default

If the data set contains no duplicate data points, MODE returns the #N/A
error value.
Does your data contain duplicate data points? If not you want to look for
MEAN or MEDIAN.
Else post an example for us to look at.
Regards,
Pat

"vmagal1" wrote:

When I try to use the mode function on a set of values, I get #N/A back as my
answer. Please help!

  #3   Report Post  
Old May 20th 05, 07:27 PM
vmagal1
 
Posts: n/a
Default

Well I figured out the problem. I was using the mode function on cells that
were calculated using a formula. I guess it didn't like that.

"Pat Flynn" wrote:

If the data set contains no duplicate data points, MODE returns the #N/A
error value.
Does your data contain duplicate data points? If not you want to look for
MEAN or MEDIAN.
Else post an example for us to look at.
Regards,
Pat

"vmagal1" wrote:

When I try to use the mode function on a set of values, I get #N/A back as my
answer. Please help!

  #4   Report Post  
Old May 20th 05, 07:49 PM
Harlan Grove
 
Posts: n/a
Default

vmagal1 wrote...
Well I figured out the problem. I was using the mode function on

cells that
were calculated using a formula. I guess it didn't like that.

....

Not the problem. If I enter the formula

=INT(1+5*RAND())

in A1:A20, MODE(A1:A20) works just fine, returning the mode of the
formula-generated values in A1:A20.

Far more likely your problem is due to number formatting that makes
many of your formulas appear to produce the same value when there are
actually differences. If I enter the formula

=5*RAND()+0.5

in B1:B20 and replace the formulas in A1:A20 with

A1:
=ROUND(B1,0)

and format A1:B20 as numbers with zero decimal places, A1:A20 and
B1:B20 appear identical, but MODE(A1:A20) returns a number while
MODE(B1:B20) returns #N/A.



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
Formula syntax error - chinese and gibberish Joshua Fandango Excel Discussion (Misc queries) 3 March 29th 05 01:27 PM
Formula error... Jambruins Excel Discussion (Misc queries) 2 February 24th 05 09:57 PM
Formula Error Mike R Excel Discussion (Misc queries) 6 January 15th 05 05:27 AM
"formula too long" error message lbaskin Excel Discussion (Misc queries) 1 January 13th 05 03:05 AM
Formula MATCH error peterfc2 Excel Worksheet Functions 0 November 8th 04 05:53 PM


All times are GMT +1. The time now is 11:15 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017