A. MAX & MIN
B. AVERAGE
C. COUNT
D. COUNTA
2006-10-24 08:49:01 · 3 answers · asked by possum 1 in Computers & Internet ➔ Software
Max & Min, Average and Count are all functions that work with numerical values, in order to return a result the field has to contain a VALUE, COUNTA however will count cells that are NOT EMPTY, no matter the content so it will give the correct answer whether there is text or values in a field. COUNT will only count the cells that contain a VALUE.
2006-10-24 09:06:46 · answer #1 · answered by argeesoftware 3 · 1⤊ 0⤋
MIN, MAX, AVERAGE, COUNT are ignoring text entries
MINA, MAXA, AVERAGEA, COUNTA, will not ignore text enries.
So when you find, VARP, you will also have VARPA for a text entries included
Enjoy my profile, I am VBAXLMan
2006-10-28 00:09:17 · answer #2 · answered by Anonymous · 0⤊ 0⤋
To make something a formula you want to initiate the cellular with "=" So for multiplication typing "=4*3" will provide the top result 12. the emblem for branch is "/" and for subtraction is "-". notwithstanding, =product(x, y, z...) can do multiplication and =quotient(x,y) can do branch in case you want to expose something as a percentage you are able to in basic terms decide on that sort because the cellular format. filter out is optimal defined in the Excel outfitted-in help. is this sufficient?
2016-12-05 04:38:16 · answer #3 · answered by ? 4 · 0⤊ 0⤋