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!
Jul-15-2011 18:43
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.
Jul-15-2011 20:59
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.
Jul-15-2011 21:02
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"
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?
Jul-15-2011 21:30
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.
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
Jul-15-2011 21:39
djshan
Supreme tranceaddict
Registered: Jul 2003
Location:
28 next month
Jul-16-2011 02:08
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.