Excel Formulas

[*Hala*]

(SUM) =sum (A1+A2+A3+A4)
(SUM) =sum (A1:A9)
(SUBTRACT) =(B2-B3)
MULTIPLY =(B1*B2*B3*B4*B5)
MULTIPLY =Product(A1:A8)
DIVISION =(C4/C5)
AVERAGE =AVERAGE(C4:E4)
PERCENTAGE =(C4/850*100)
MAXIMIZE =MAX(B2:B3)
MINIMIZE =MIN(B3:B9)
POWER =2^2
POWER =POWER(2,4)
DATE =TODAY( )
TIME =CTRL+SHIFT+:
COUNT FILL CELLS =COUNT(B1:B9)
BLANK CELLS = COUNTBLANK(B5:B9)
DATE AND TIME =NOW( )
SIN =SIN(50)
COS =COS(50)
TAN =TAN(80)
IF STATEMENT =IF(A1>450,"PASS","FAIL")


1=COUNTIF (B1:B6,"2")
2=COUNTIF (A1:A6,"bari")

3=SUMIF (A1:A6,"bari", B1:B6)


4=TEXT(4444,"$00,00.00")
5=ABS(-252652)
6=CODE("F")
7=PI()
8=25*PI()
9=DAY("8-2-2004")
10=MONTH("5-12-2004")
11=YEAR("2-5-2004")
12=SUM(Sheet1!K17:Sheet1!K23)
13=SQRT(81)
14=AND(2+2=4,2+5=7)
15=OR(1+1=1,2+2=5)
16=MODE(2,3,8,7,7,7,8,7,8,7)
17=INT(5.67)
18=MOD(13,2)
19=LOG(30)
20=ACOS(0.45)
21=ATAN(0.45)
22=LEFT("computer",3)
23=RIGHT("computer",2)
24=MID("computer",4,3)
25=UPPER("computer")
26=LOWER("COMPUTER")
27=CHAR(65)
28=Hyperlink("c"\my documents\khan.txt",my file")
29=LEFT(A4,FIND(" ",A4,1))
30=RIGHT(A4,LEN(A4)-FIND("*",SUBSTITUTE(A4," ","*",LEN(A4)-

LEN(SUBSTITUTE(A4," ","")))))

31 =LEFT(A4,FIND("*",SUBSTITUTE(A4," ","*",LEN(A4)-

LEN(SUBSTITUTE(A4," ",""))))-1)

32 =LEFT(TRIM(A2),FIND(" ",TRIM(A2),1))&RIGHT(TRIM(A2),LEN(TRIM(A2))-

IF(ISERROR(FIND(" ",TRIM(A2),FIND(" ",TRIM(A2),1)+1)),FIND(" ",TRIM(A2),1),FIND(" ",TRIM(A2),FIND(" ",TRIM(A2),1)+1)))

33=Rept("khan",9)
34=Sheet1! E5
35=INT(CONVERT(A2,"ft","ft"))&" feet " &INT(OD(CONVERT(A2,"ft","in"),12))& " inches"
36=INT(CONVERT(A2,"kg","lbm"))&" lbs " &INT(
MOD(CONVERT(A2,"kg","ozm"),16))& " oz"
1: =EVEN(33)
2: =ODD(34)
3: =COMBIN(5,2)
4: =WEEKDAY("1/29/04")
5: =DAYS360("1/28/04","1/1/05")
6: =FACT(5) exp:1*2*3*4*5
7: =LEN("jhdfhjsdhfjshdfks")
8: =DEGREES(40)
9: =HOUR("22:17:55")
10: =MINUTE("12:56:30")
11: =SECOND("12:55:32")
12: =COUNTA(D6:F19)
13: =4<>7 & =4=7 & =4=4
14: =DATEDIF(A1,NOW(),"d")
15: =DATEDIF(A1,NOW(),"m")
16: =DATEDIF(A1,NOW(),"y")
17: =DATEDIF(A1,NOW(),"ym")
18:=DATEDIF(A1,NOW(),"md")
19: =DATE(YEAR(NOW()),1,28)
20: =CELL("filename",A1)
21: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,LEN(CELL("filename",A 1))-FIND("]",CELL("filename",A1)))
37=INT(CONVERT(G6,"KG","LBM"))
38=INT(MOD(CONVERT(G7,"KG","OZM"),16)

39=VLOOKUP(E1,A$1:B$8,2,1)


40=Round ((A2+B2)/C2),2)

[sheem]

Re: excel formula........

woow zaberdast :clap: :clap:

tutorail mai kaam aye ga yeh :x

thanx hala:phool:

[Yaaram]

Re: excel formula........

thanx hala.........bohat informative post hay yeh......bohat shukrya and keep sharing :)

[جنیداختر]

Re: Excel Formulas

wow kiya zabardast sharing ki hai Hala :)

[Muhammad Khalil]

Re: Excel Formulas

really gud information
i often need this

[*Hala*]

Re: Excel Formulas

thank you :)
Adnan jii :rose
Sheem jii :rose
KHL jii:rose
Jums jii:rose

[.]

Re: Excel Formulas

excel kab say choora hai hai ab to bhool bhi gai :tauba

chaloo tumhari post kaam aye gee usay yaad karnay main :phool: