Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Statistical Challenge
#56
ceiling(0, 0) works OK because of the first IF statement (returns 0), but the actual function in gnumeric (a spreadsheet compatible with excel) returns a #num! error. Do you think mine should too?

ceiling(5, -5) returns 5, which is in theory 5 rounded up to a multiple of -5, but I think that should return an error instead. What about anyone else?

ceiling (0,1) returns 0, which is just like the actual function, but don't you think that should return 1 instead?

ceiling(1,0) was a good one, it froze my Linux based QBasic :wink: . I fixed this by checking if the significance was 0, and returning error code 5 if it did. (Illegal function call).

Thanks for your help, agamemnus.
Reply


Messages In This Thread
Statistical Challenge - by oracle - 04-26-2003, 03:41 AM
Statistical Challenge - by Agamemnus - 04-27-2003, 07:21 AM
Statistical Challenge - by oracle - 04-27-2003, 11:53 AM
Statistical Challenge - by Agamemnus - 04-27-2003, 05:12 PM
Statistical Challenge - by na_th_an - 04-27-2003, 08:00 PM
Statistical Challenge - by oracle - 04-28-2003, 08:52 AM
Statistical Challenge - by Agamemnus - 04-28-2003, 05:31 PM
Statistical Challenge - by oracle - 04-29-2003, 09:40 AM
Statistical Challenge - by relsoft - 04-29-2003, 01:37 PM
Statistical Challenge - by Neo - 04-29-2003, 05:05 PM
Statistical Challenge - by oracle - 04-30-2003, 06:16 AM
Statistical Challenge - by Neo - 05-01-2003, 06:43 PM
Statistical Challenge - by Agamemnus - 05-01-2003, 07:11 PM
hm.. - by Lanzaa - 05-01-2003, 08:10 PM
Statistical Challenge - by Agamemnus - 05-01-2003, 09:09 PM
Statistical Challenge - by toonski84 - 05-02-2003, 02:23 AM
Statistical Challenge - by oracle - 05-02-2003, 11:43 AM
Statistical Challenge - by toonski84 - 05-02-2003, 04:39 PM
Statistical Challenge - by oracle - 05-03-2003, 04:23 AM
Statistical Challenge - by Neo - 05-03-2003, 04:36 PM
Statistical Challenge - by na_th_an - 05-03-2003, 05:30 PM
Statistical Challenge - by Agamemnus - 05-03-2003, 06:04 PM
Statistical Challenge - by na_th_an - 05-03-2003, 07:26 PM
Statistical Challenge - by whitetiger0990 - 05-04-2003, 01:24 AM
Statistical Challenge - by oracle - 05-04-2003, 12:09 PM
Statistical Challenge - by whitetiger0990 - 05-04-2003, 06:26 PM
Statistical Challenge - by na_th_an - 05-04-2003, 06:43 PM
Statistical Challenge - by oracle - 05-05-2003, 06:09 AM
Statistical Challenge - by na_th_an - 05-05-2003, 03:57 PM
Statistical Challenge - by Neo - 05-06-2003, 01:11 PM
Statistical Challenge - by oracle - 05-06-2003, 01:37 PM
Statistical Challenge - by na_th_an - 05-06-2003, 04:35 PM
Statistical Challenge - by oracle - 05-07-2003, 03:00 AM
Statistical Challenge - by DrV - 05-14-2003, 02:08 AM
Statistical Challenge - by oracle - 05-14-2003, 07:41 AM
Statistical Challenge - by DrV - 05-16-2003, 03:55 AM
Statistical Challenge - by oracle - 05-16-2003, 04:00 AM
Statistical Challenge - by Agamemnus - 05-17-2003, 01:27 AM
entry - by Meg - 05-17-2003, 02:29 AM
Statistical Challenge - by oracle - 05-17-2003, 09:05 AM
Re: entry - by na_th_an - 05-17-2003, 05:13 PM
you don't understand, oracle. - by Agamemnus - 05-17-2003, 06:48 PM
Statistical Challenge - by oracle - 05-19-2003, 01:28 AM
Statistical Challenge - by Agamemnus - 05-19-2003, 07:38 AM
Statistical Challenge - by oracle - 05-19-2003, 09:07 AM
Statistical Challenge - by toonski84 - 05-19-2003, 09:40 AM
Statistical Challenge - by oracle - 05-19-2003, 09:55 AM
Statistical Challenge - by Neo - 05-19-2003, 03:32 PM
Statistical Challenge - by oracle - 05-20-2003, 06:34 AM
ceiling - by Meg - 05-20-2003, 01:22 PM
Statistical Challenge - by oracle - 05-20-2003, 01:41 PM
Statistical Challenge - by Neo - 05-20-2003, 01:45 PM
Statistical Challenge - by oracle - 05-21-2003, 07:40 AM
Statistical Challenge - by Agamemnus - 05-21-2003, 08:41 AM
Statistical Challenge - by oracle - 05-21-2003, 09:56 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)