# Use of =sum =if =min =max =ave and examples in MS Excel

1
by JC10
dont mind that /> hehe
wait... just noticed, there's no =AVE formula thingy... did you mean =AVERAGE ???? o.O
sorry just a typo..

2016-01-18T18:36:03+08:00
=SUM - sum of the cells selected or the value entered.
=IF - (sorry, can't explain it well) States if the logical question (thingy) is true or not.
=MIN - selects the least value of the value entered or among the cells selected.
=MAX - selects the greatest value among the value's entered or among the cells selected
=AVERAGE - finds the average of the values entered or of the cells selected.

EXAMPLES
Try it on MS Excel and you'll see. ☺

=SUM (A9,A5,B6,F7,E8,F9,C2,D4)
=SUM (2419,2134,321)

=IF(A9<100,"True","False")

=MIN(92,32,54,45,64)
=MIN(B9,B4,C3,A5)

=MAX(32,42,63,64,75)
=MAX(A9,B2,B5)

=AVERAGE(84,98,86)
=AVERAGE(A9,B9,C9,D9)

I hope it help. ☺
about the formula =IF , if the statement is true or not, well it's random okay? also, in typing the formula in the cell or in the formula box, make sure you'll put " (quotation marks thingy) if not, you'll get an error (#NAME?)
Thanks, don't worry, I just need to make my own definition and you helped. ☺