Confusion on Argument

[d_bht]

Dear Sir,

I am just a beginner in MS Excel. I have learned & practice on MS Excel Formulas. However, I am cofused on arguments as there is no one to explain or guide me. What actually the arguments states.

Example: =IF(Average(F2:F5)>50, SUM(G2:G5),0)

I understand from above formula is: if the average of F2 to F5 is less than 50 only.
Apart from that I don't understand what actually SUM (G2:G5) tells and the comma(,) & zero(0). Kindly explain.

Thanx.

 

[Yahya]

Dear Sir,

I am just a beginner in MS Excel. I have learned & practice on MS Excel Formulas. However, I am cofused on arguments as there is no one to explain or guide me. What actually the arguments states.

Example: =IF(Average(F2:F5)>50, SUM(G2:G5),0)

I understand from above formula is: if the average of F2 to F5 is less than 50 only.
Apart from that I don't understand what actually SUM (G2:G5) tells and the comma(,) & zero(0). Kindly explain.

Thanx.

I understand from above formula is: if the average of F2 to F5 is less than 50 only.

No
the condition here if the average is greater than 50

If Value Is true : the average greater than 50 , Excel Will sum the range G2:G5 with this formula SUM(G2:G5)
if average less than 50 the result will be Zero

==========
read the help for IF Function
=IF(logical_test,value_if_true,value_if_false)

HTH

 

[Marcelo Branco]

Hi,

Take a look at
http://www.techonthenet.com/excel/formulas/if.php

This
Average(F2:F5)>50
means
if the Average of F2 to F5 (a range comprising F2 F3 F4 F5) is greater than 50

SUM(G2:G5)
sums the values in the range G2:G5, ie, G2 G3 G4 G5

M.

 

[d_bht]

Thank you sir's its my first experience in such system. Hope I ll always have a support and suggestion from else where.