Excell how many formulas do you know
some of my favourtites are.
=rand() creates a random number between .99 – .01
=if(query, {if true}, {if false}) good fun
=sum(startcell:endCell)
some others we learn today
=count(start:finsih) counts the number of entries numbers and text
=counta(start:finish) counts the number of cells with characters only
Here By Accident Jman
morphia
Hi Justin,
It seems that you maybe the only person paying attention in class.
Loved the blog
some basic ones
=(c1+c2) is basic adding equasion
=(c1-c2) is basic subtraction
oh i see getting marks attention
ok today we learned about vlookup
very interesting very fun
it relates one cell to a table and gets the selected number word for the amount in the cell..
also another good thing was styles for the number and stuff so it can have like a graph ion the background on the list of cells as a percentage.
linking all the pages together and typing on the first page/sheet groups them together and it writes on all the sheets the same in the same cell..