EXCEL FARMOLAS



Excel formula to gather all uyluz
1,  =SUM(A1.A20)
2, =SUM(A1,A10)
3, =sum(A1,A10,20)
4, =sum(A1,A10,C1:C10)
Excel formula 2
=sum(Ceal1+cal2+cal7+cal10)










counat farmula:
1,  =counatblank(A1,A100)
if formula,
1=if(and(A1>5,B4<1000),5000,0)

=IF(and(C4,.70,G4<20),"pass","fail")

Excel to enter the date and day, formula
=date(2013,03,03)

Comments

Popular posts from this blog

ms excel formulas

COREL DRAW