|
What is the average age of TA's members??? (pg. 16)
|
View this Thread in Original format
| tubularbills |
| 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! |
|
|
| VDub |
| quote: | Originally posted by Halcyon+On+On
Mentally or physically? |
26 & 37... |
|
|
| Acton |
| 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" :p |
|
|
| tubularbills |
| quote: | Originally posted by Acton
=ROUND(AVERAGE($first post:$last post),0)&" years old" :p |
nonsense, that's what formatting cells is for to call the cell a regular number and zero numbers after the decimal.:toocool: |
|
|
| Acton |
| 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.:toocool: |
Not if you need it to be a whole number, though. Simply formatting the cell to zero decimal places doesn't change the value :toocool: |
|
|
| tubularbills |
| 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 :toocool: |
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? |
|
|
| Acton |
| 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. |
|
|
| tubularbills |
| 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 :( |
|
|
|
|
