عبدالقدوس

(SUM) =sum (A1+A2+A3+A4)
(SUM) =sum (A1:A9)
(SUBTRACT) =(B2-B3)
MULTIPLY =(B1*B2*B3*B4*B5)
MULTIPLY =Product(A1:A
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,2
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)

__________________

منتظمین

بہت اچھے فارمولے ہیں۔ لیکن اگر ان کے ساتھ اپ کوئی ایکسل کی شیٹ بھی نتھی کر دیتے تو لوگوں کو اس سے سیکھنے میں کافی مدد ملتی۔

والسلام

__________________
تم سپاہی نہیں ہو پیشہ ور قاتلو!

محمدعدنان

واہ بہت خوب جناب
شکریہ

پاکستانی

شکریہ

عبدالقدوس

پسند کرنے کا شکریہ