MUBASHIR MOBILES

sum =SUM(B3:B14) sumif  =SUMIF(B3:B14,"<100") count  =COUNT(B3:B14) counta  =COUNTA(B3:B14) text =COUNTA(B3:B14)-COUNT(B3:B14) count blank =COUNTBLANK(B3:B14) total cells  =COUNTA(B3:B14)+COUNTBLANK(B3:B14) average =AVERAGE(B3:B14) min =MIN(B3:B14) max =MAX(B3:B14) small =SMALL(B3:B14,1) large =LARGE(B3:B14,1)

( SUM FARMOLAS ) =SUM (A1. A20) =SUM (A1:A20) =SUM (A1, A2, A4, A20) IF FARMOLA =IF (C4>50,”PAAS”,”FAIL”) Excel formulas are used to support operators do < , Is small >, large = , equal <> , that small is big >= , bigger equals <= , is equal small IF AND FARMOLA (If you have a choice in what formula would blind Addiction) =IF(AND(F1>5,G4>500),G4*7/100,”0”)