News:

If you need instructions on how to get through the hotels, check out the enclosed instruction book.

Main Menu

Anybody know how to use Excel?

Farted by catclock, January 15, 2009, 09:36:52 PM

Previous topic - Next topic

0 Members and 0 Guests are viewing this topic.

catclock

I have 1000 random numbers between 0 and 100 what would be the code to get it to tell me how many of those numbers are below 30 and how many are above 30?

うんこ

Marlin Clock

Why can't you just do it yourself?

catclock

Quote from: Marlix Wright;1498503Why can't you just do it yourself?

I'm trying but I can't figure it out ;w; I tried using =SUMIF but I couldn't get it to work

うんこ

Maltese

No one knows how to use excel

NO ONE

catclock

Quote from: Franklin G. Hamilton;1498507have you tried putting in different anime faces into the formula editor


you probably have

Yes actually I put in >w< but it didn't work!! ;ω;

Quote from: Marlix Wright;1498512Okay, well I meant manually. Why do you need to use Excel?

because there's 1000 trials and it changes everytime I do anything =ω=

うんこ

Marlin Clock

Okay, well I meant manually. Why do you need to use Excel?

catclock

Got it
=COUNTIF(B2:B1001,"<5")

it was that easy I forgot about that command silly me ^ω^

うんこ

iPodClock

max signature height is 250px not 431, bro.

buttplug

Quote from: Marlix Wright;1498512Okay, well I meant manually. Why do you need to use Excel?

Because computers are made to do dingen like this for us. It would take longer to go through manually, and probably with some error. Also if he (or maybe it, this is catclock...) ever needs to do this again he (it) will know how.

salt

YEAH did you put in anime faces you fucking anime FREAK just die die die die
hej.

okkkkkkkk,k


http://www.last.fm/user/SaltClock


vvvvvvvvvvvvvvvvvv

catclock

Quote from: Marlix Wright;1498512Okay, well I meant manually. Why do you need to use Excel?

because there was 1000 trials you want to go through 1000 boxes and count which one is above 5 and which one is below then be my guest B]

うんこ

Marlin Clock

Wait, in the beginning you said thirty.

I don't quite understand the reason behind this. Some kind of school project where you needed to process all the data? Also, by inputting the data didn't you need to know the number? Couldn't you just make a note of which ones were above or below 5?

Marlin Clock


buttplug

Quote from: Marlix Wright;1498849Wait, in the beginning you said thirty.

I don't quite understand the reason behind this. Some kind of school project where you needed to process all the data? Also, by inputting the data didn't you need to know the number? Couldn't you just make a note of which ones were above or below 5?

If he had a file with a list of the numbers he didn't have to input all the data manually. If he did of course it would be better to do it manually.

Either way why should it matter why he needed to do it?

Marlin Clock


catclock

Quote from: Marlix Wright;1498849Wait, in the beginning you said thirty.


Quote from: Taiga Aisaka;1498501I have 1000 random numbers between 0 and 100 what would be the code to get it to tell me how many of those numbers are below 30 and how many are above 30?

Blindddd

うんこ

Marlin Clock

Quote from: Taiga Aisaka;1498501I have 1000 random numbers between 0 and 100 what would be the code to get it to tell me how many of those numbers are below 30 and how many are above 30?
Blindddder

catclock

Quote from: Marlix Wright;1499323Blindddder

Dumbass I meant from those 1000 random numbers how many of those random numbers are above 30 and how many of those random numbers are below 30 stupiddd =ω=

God obviously didn't give you the gift of reading

うんこ