Become a part of the TranceAddict community!Frequently Asked Questions - Please read this if you haven'tSearch the forums
TranceAddict Forums > Main Forums > Chill Out Room > What is the average age of TA's members???
Pages (18): « 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 [16] 17 18 »   Last Thread   Next Thread
Share
Author
Thread    Post A Reply
tubularbills
Max Power!



Registered: Apr 2003
Location: Middle of fucking nowhere

quote:
Originally posted by KilldaDJ
=average($first post:$last post)


haha, that's awesome. (glad to see someone else is an excel nerd)

Man, you guys I'm going to be 29 here in a few months and I'm getting more and more gray hair. blech!

Old Post Jul-15-2011 18:43  United States
Click Here to See the Profile for tubularbills Click here to Send tubularbills a Private Message Add tubularbills to your buddy list Report this Post Reply w/Quote Edit/Delete Message
VDub
Scoundrel



Registered: Feb 2008
Location: Toronto

quote:
Originally posted by Halcyon+On+On
Mentally or physically?


26 & 37...


___________________
quote:
Originally posted by chinamon
chinamon is INCH MOAN.
LOL so fitting.

Old Post Jul-15-2011 20:59 
Click Here to See the Profile for VDub Click here to Send VDub a Private Message Add VDub to your buddy list Report this Post Reply w/Quote Edit/Delete Message
Zyklon_Jay
wehrmacht bitches be at!



Registered: Oct 2010
Location: Ici William Bumbray du service de police de la communauté urbaine de Montréal Esti.

6 & 12.


___________________

quote:
Originally posted by EddieZilker
Oh, preese, so sorree for intorrerance fwum esss russer. He maka fun of you because you tarking in racial stereotype. I aporogize for heem. He not know how behave. Preeze accept aporogee.
Ching chang chow yun fat, Mr. Roboto.

Old Post Jul-15-2011 21:02 
Click Here to See the Profile for Zyklon_Jay Click here to Send Zyklon_Jay a Private Message Visit Zyklon_Jay's homepage! Add Zyklon_Jay to your buddy list Report this Post Reply w/Quote Edit/Delete Message
Acton
Like a FCKNG BIRD



Registered: Mar 2002
Location: London

quote:
Originally posted by tubularbills
haha, that's awesome. (glad to see someone else is an excel nerd)


=ROUND(AVERAGE($first post:$last post),0)&" years old"


___________________

>>> Beatport Stuff <<<

Old Post Jul-15-2011 21:08  England
Click Here to See the Profile for Acton Click here to Send Acton a Private Message Visit Acton's homepage! Add Acton to your buddy list Report this Post Reply w/Quote Edit/Delete Message
tubularbills
Max Power!



Registered: Apr 2003
Location: Middle of fucking nowhere

quote:
Originally posted by Acton
=ROUND(AVERAGE($first post:$last post),0)&" years old"


nonsense, that's what formatting cells is for to call the cell a regular number and zero numbers after the decimal.

Old Post Jul-15-2011 21:12  United States
Click Here to See the Profile for tubularbills Click here to Send tubularbills a Private Message Add tubularbills to your buddy list Report this Post Reply w/Quote Edit/Delete Message
Acton
Like a FCKNG BIRD



Registered: Mar 2002
Location: London

quote:
Originally posted by tubularbills
nonsense, that's what formatting cells is for to call the cell a regular number and zero numbers after the decimal.


Not if you need it to be a whole number, though. Simply formatting the cell to zero decimal places doesn't change the value


___________________

>>> Beatport Stuff <<<

Old Post Jul-15-2011 21:22  England
Click Here to See the Profile for Acton Click here to Send Acton a Private Message Visit Acton's homepage! Add Acton to your buddy list Report this Post Reply w/Quote Edit/Delete Message
tubularbills
Max Power!



Registered: Apr 2003
Location: Middle of fucking nowhere

quote:
Originally posted by Acton
Not if you need it to be a whole number, though. Simply formatting the cell to zero decimal places doesn't change the value


you can always =ABS(etc...) it too. that'll round for you if the cell is formatted for zero spots after the decimal place. at least I think?

Old Post Jul-15-2011 21:30  United States
Click Here to See the Profile for tubularbills Click here to Send tubularbills a Private Message Add tubularbills to your buddy list Report this Post Reply w/Quote Edit/Delete Message
Acton
Like a FCKNG BIRD



Registered: Mar 2002
Location: London

quote:
Originally posted by tubularbills
you can always =ABS(etc...) it too. that'll round for you if the cell is formatted for zero spots after the decimal place. at least I think?


Na, the ABS function is the absolute function, which just removes the negative sign if the number is negative. If the cell is formatted to zero decimal places then it will appear as a whole number, yeah, but the actual value will remain the same.


___________________

>>> Beatport Stuff <<<

Old Post Jul-15-2011 21:36  England
Click Here to See the Profile for Acton Click here to Send Acton a Private Message Visit Acton's homepage! Add Acton to your buddy list Report this Post Reply w/Quote Edit/Delete Message
tubularbills
Max Power!



Registered: Apr 2003
Location: Middle of fucking nowhere

quote:
Originally posted by Acton
Na, the ABS function is the absolute function, which just removes the negative sign if the number is negative. If the cell is formatted to zero decimal places then it will appear as a whole number, yeah, but the actual value will remain the same.


ok, i see what you mean now!

we're dorks. old ones at that

Old Post Jul-15-2011 21:39  United States
Click Here to See the Profile for tubularbills Click here to Send tubularbills a Private Message Add tubularbills to your buddy list Report this Post Reply w/Quote Edit/Delete Message
djshan
Supreme tranceaddict



Registered: Jul 2003
Location:

28 next month

Old Post Jul-16-2011 02:08  Canada
Click Here to See the Profile for djshan Click here to Send djshan a Private Message Add djshan to your buddy list Report this Post Reply w/Quote Edit/Delete Message
Spam
OMG Hai2U!



Registered: Dec 2004
Location: Mississauga, Ontario

26


___________________
Captain Planet is gey.
Water, Fire, Earth, Wind, Heart???
These forces are supposed to combine to create Captain Planet?
Bullshit.
Those forces combine to create a soaking, boiling mudstorm on Valentine's Day.

Old Post Jul-16-2011 02:27  Canada
Click Here to See the Profile for Spam Click here to Send Spam a Private Message Add Spam to your buddy list Report this Post Reply w/Quote Edit/Delete Message
VAR
Suspended User



Registered: Mar 2006
Location: 8==D~

low 40s


___________________

Old Post Jul-16-2011 03:50  Sweden
Click Here to See the Profile for VAR Click here to Send VAR a Private Message Visit VAR's homepage! Add VAR to your buddy list Report this Post Reply w/Quote Edit/Delete Message

TranceAddict Forums > Main Forums > Chill Out Room > What is the average age of TA's members???
Post New Thread    Post A Reply

Pages (18): « 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 [16] 17 18 »  
Last Thread   Next Thread
Click here to listen to the sample!Pause playbackHouse track sample [2006] [2]

Click here to listen to the sample!Pause playbackMuzzaik - It Ain't Right versus Rhythm Of Life (Tommy Boy Bootleg Mix) [2006]

Show Printable Version | Subscribe to this Thread
Forum Jump:

All times are GMT. The time now is 16:33.

Forum Rules:
You may not post new threads
You may not post replies
You may not edit your posts
HTML code is ON
vB code is ON
[IMG] code is ON
 
Search this Thread:

 
Contact Us - return to tranceaddict

Powered by: Trance Music & vBulletin Forums
Copyright ©2000-2026, Jelsoft Enterprises Ltd.
Privacy Statement / DMCA
Support TA!