vibram five fingers speed

The Vibram Five Fingers Speedcould be described simultaneously as both a retro-styled sneaker (or trainer) that features a mesh-like upper,louis vuitton monogram multicolore, steel eyelets and piped laces, subdued but slick Vibram branding, and simple black-and-white coloring and a foot friendly,louis vuitton suhali lockit bag, minimalist, toe-loving foot glove.
The foundation at the base of the Vibram Five Fingers Speed is the running-specific padded sole that we've already gotten a good look at via the Vibram Five Fingers Bikila. This sole features little padded platforms that are beefiest at the forefoot. Additionally,louis vuitton handbag locks, rather than Vibram rubber at the arch,louis vuitton on sale, the Speed has a devoted polyurethane* arch covering.
Notably,newest louis vuitton handbags 2011, from my initial testing of the Speed as compared to the Bikila,louis vuitton damier azur speedy 25 or 30, it seems that the Speed does not have the extra 3mm polyurethane insole at the forefoot,louis vuitton canvas wallet monogram, which means that you get a bit more ground feel in the Five Fingers Speed as compared to the Bikila. The Speed does feature the same dri-lex fabric on the footed,louis vuitton alma handbag, which is quite comfortable.
As far as having a laced, tongued Vibram Five Fingers Speed go,louis vuitton maui handbag, it seems the Speeds are no easier to put on than Bikilas,louis vuitton monogram vernis red, but if I had to speculate,louis vuitton white murakami papillon, I'd say that the "customizability" of fit afforded via laces should make the Speed a comfier fit for individuals with higher insteps. Really,louis vuitton monogram mini lin speedy, a custom-fit upper as compared to a limited stretch upper
The addition of a padded tongue and padded collar do make the Speed feel a bit more shoe-like on the top of the foot,most popular louis vuitton bags 2010, so you won't get as much of an airy feel as with Classics or even KSOs. As far as finish is concerned, my initial appraisal of the Speeds is that they have a nice quality to them. We'll see how they hold up over time
Finally, theVibram Five Fingers Speed are,louis vuitton damier geant messenger, as I've come to expect,louis vuitton vintage jewlery case, comfortable on my bare feet and has a feel not unlike the Bikila. The mesh-upper is smooth on the inside and the seams from the tongue are "there" but pretty harmless — at least for casual wear. The Speeds size similarly to Bikilas or KSOs.

[i0love0u]

The maintenance of mbt skechers shoes,moncler vest men sale
Whether MBT shoes is comfortable or not, fit or not, only you know. If you hesitant between fit and the beautiful,moncler jackets on sale uk, it must buy which is suitable for the feet! MBT shoes into MBT walking Shoes,moncler jackets for women for sale, MBT shoes UK, MBT skechers shoes. MBT shoes can exercise your spine,moncler outlet uk review, the effect is good,moncler vest cheap, both challenging and very gentle. Used of biomechanical design can enhance your physical,moncler kids sale, as well as help you improve the method of using the muscles and joints.
After the MBT skechers shoes bought, before the high-intensity activity we must run for some time,moncler down jackets women, in order to avoid the activity painful, due to the experience is not running. Eagle Tip: When wearing new shoes wear two pairs of socks, which a thin layer of socks,moncler jackets for men blue, one pair of thick socks outside,moncler outlet stores uk, so make socks reduce friction between the shoes on the foot,jackets moncler for sale, it is unlikely there will be blisters the phenomenon.
Back after each trip must maintain your shoes, especially high-end MBT skechers shoes, with a soft brush to clean out the dirt, and then maintenance of footwear care agent. If you want one more convenient method to clean your mbt walking shoes, we suggested that you use the shoe polish. Simple elimination instep’s dust then spreads evenly this liquid shoe polish in the MBT shoes dermis black. This section of shoe polish’s formula can restore shoes’ luster,moncler outlet usa, and after having done, immediately presents luminously,moncler jackets for women ski jackets, does not need extra polishing. Prevent water seepage, exposure,moncler jackets discount, and roasted; washed,moncler women vest cheap, avoid direct sunlight. These habits are good for your shoes life,cheap moncler jackets for men!

[ug6ht3mh8tg]

So beautiful. It hurt. Nayi Ju, making you feel bad of it. 【Go back and do sign it took away】 - Qzone log


| Back to logs list

Reprinted from alumni of the user at 06:55 on May 25 2010 read (loading. ..) Comments (0) Category: Personal Diary

1. such a person, or such a story.
2. he returned in the past, did not return.
3. to be more strong, dare not forget.
4. look at someone else's story, his tears flowing.
5. I was the only umbrella, still wet one?
6. has always been shallow edge of nowhere Wife?
7. actors art, a lifetime horizon.
8. alone in the sea every step of the World, Road no return, full cream Yen.
9. Night Wei Liang, lights dim, ambiguous cleared, complains mildly.
10. being right,belstaff outlet, deserted.
11.'ve heard people say that memory is a bridge, but it is the way to the prison of loneliness.
12. Happy to you, lonely yourself
13. He is in cardamom, who promised whom the end of time.
14. eyes for you the rain, the heart is an umbrella for you.
15. love so short, forgetting is so long ... ...
16. I remember, you do not miss.
17. really sad from the last.
18. I want to cry, but I do not know how to tears.
19. that song about our songs, you sing the ending Who listen.
20. flowery Meijuan, Homecoming.
21. some things turned around is a lifetime.
22. youth, we give up, thought it was just a relationship, and then I, that is actually a life.
23. I'm still waiting for you, but you have forgotten who come here.
24. grief is greater than satiated.
25. I'm fine, no noise no trouble do not show off, do not wronged do not laugh, do not need others to know.
26. I forget you turned on the passerby, so how can accompany you to the horizon Love wasted?
27. you go flyover, underpass I go.
28. stand up to Homecoming, escape youth here.
29. old lang syne, only a misunderstanding.
30. busy are they,belstaff jackets outlet, and not mine.
31. butterflies fly, but the sea.
32. and love quarrel, and the stranger speak from the heart.
33. listening to sad songs, happiness and drama.
34. the Bowl.
35. think about you some happiness, happiness was a bit sad.
36. fool, we are the same.
37. the original feel bad, like this; hypnosis yourself, tell yourself, and happiness.
38. you sat on the sofa wide, you love the music stopped, I waited for you day become a display ... ...
39. this winter does not surprise me ... ...
40. I'm your kite line in your hand, I can only accompany the wind ... ...
41. just want to hear you say, wish me happiness.
42. Looking back lights as the old, light shake hands.
43. Love is I turned my preparedness, but you still hug me.
44. next life is no longer human, no longer meet the next life.
45. friends are envious of me, in fact, they are envious of me. Love you long time, waiting for you, but also a long time, now, I'm leaving you, than the long, long time even for a long time ... ...
46. forget the happy, not unhappy.
47. drag your hand once I have met.
48. young and frivolous, happy time.
49. I do not care I do not care about you.
50. the next intersection, misses some kind of temperature.
51. I believe the world is always so beautiful.
52. I used all my fruit fruit, a Yen for your laughter.
53. uncomfortable habit, habits, thoughts and habits, and you, but it has not been accustomed to see you;
54. no place to place, our distant youth.
55. I heartbreak, how could you lose me.
56. lonely too will attack first.
57. get other people's secrets, will lose their happiness.
58. is not madness, not survived.
59. just like old love, always forget that one day, had actually thought that love.
60. hand, the lifeline to cross.
61. living in a fairy tale from heaven closer ... ...
62. In the long run, we are all dead.
63. I actually still love him!
64. Sh ... ... listen to the voice of broken heart ... ...
65. I was crossing the street, where were you?
66. those who are allowed to wayward years, called the youth ... ...
67. I have money, you come home!
68. forget, is the most helpless love.
69. I want to love him.
70. your happiness is obvious, no place to hide my panic.
71. If I turned around, no one will see my tears, right?
72. We passed so many tests and finally returned to the origin ... ...
73. make you crazy in the place without me, let me be strong in the world without you.
74. Every day, allow yourself indulge once, cry once, just once ... ... the rest of the time, had to smile happily.
75. for their cruel, will make you happy.
76. I am a good man, do not hurt me.
77. I was protected by a shadow.
78. can not escape, and finally will become old ... ...
79. those who will eventually make you fall into the trap, and a start is always good.
80. love and death, in which colder?
81. You turn around, I go downstairs.
82. I just want to ask you, if I look back, you are still alive?
83. When you do the time, no one will remember; when you are wrong, even the breathing is wrong.
84. wait, is the first old life.
85. That is very, very good, but I chose not to like.
86. as a man no longer want, anything can be put down.
87. who's lonely, cover my Chinese clothes. Who Sang Hua, covered my shoulder.
88. pray heaven and earth pass up a pair of lovers, fear not happen ever happened.
89. the highest state of love can stand the plain is fleeting.
90. fairy tale is over, forgotten is happiness.
91. initially did not know, and ultimately do not recognize each other.
92. Health and wrong, not afford to die.
93. happiness is to find a warm person for life.
94. there is no trouble, but no return.
95. I like it myself, I remember our past.
96. left, let alone wish me happy, what qualifications you wish me happiness?
97. does not understand the weak had been strong.
98. Do not rely on others, you also can rely on when it is put out.
99. perhaps gone too far the price is loneliness.
100. Do not deceive me, you know that even your lies I will believe it.
101. to leave, please, never to return.
102. I'm nostalgic, because I do not see you and the future.
103. Please do not pretend to be nice, I'm a fool would take it seriously.
104. love the show, I'm not acting.
105. every step we have to go too early, ah. Before learning to love into the understanding of the Society.
106. before the break, before the end of the learn to face.
107. my life two of the most fortunate event, it is time finally to my love for you is depleted; one, a long time ago that one day I met you ... ...
108. waiting for your concern, until I closed the heart.
109. finish the same street, back to two of the world.
110. think about you some happiness, happiness was a bit sad.
111. you know what to do I guess, I am you can not think irrelevant.
112.. called the most memorable, is never remembered, but will never forget.
113. Who Who really seriously, who for whom distressed.
114. thank you for the unfeeling, so I learned to give up hope.
115. When the tears stream down, know, separate is another to understand.
116. I really love you, close your eyes, thinking that I could forget, but shed tears, but did not deceive themselves.
117. Sometimes, love is kind of damage. Cruel people, choose to hurt other people, good people, choose to injure themselves.
118. life is most regrettable, than to simply give up that should not give up, and stubbornly, insisted should adhere to.
119. face to the happy, other people see. Who can feel the pain of my heart.
120. Do not say love, a promise is a debt owed!
121. is not unwilling to give up a die heart.
122. the pain had not felt the pain after, and some will be a cold heart.
123. in between the wandering and despair of pardon, the only feeling is that injury injury injury!
124. longing for a taste, like drinking a cup of cold water, drop by drop and then cemented in tears.
125. like a person is not wrong, it would be wrong in like a dislike themselves.
126. can not refuse to start, could not resist the end.
127. wait ..... may not be easy; hurt ...... but easy.
128. the Bowl, when the only way is unusual
129. rather proud of the mold, not to humble love.
130. near close to you hurts, leave you far from happy.
131. Sometimes, not the other side do not care about you, but you see the other side is too important.
132. giving true will be true, but it may hurt the total; to keep a distance, can protect themselves, but destined never lonely.
133. Facts have proved that love can withstand wind and rain, but can not stand plain; friendship can stand the plain, but can not withstand the wind and rain.
134. If you are not happy, not happy, then let her go; If you want to, does not fit, then pain!
135. Sometimes the explanation is unnecessary --- the enemy does not believe your explanation, friends do not need your explanation.
136. in the way of love, the biggest mistake is to miss!
137. love, courage, friendship requires loyalty, affection and gas needs, work needs strength.
138. a nobody to share the joy, not happiness; a nobody to share the pain, it is the most terrible pain.
139. Growing old is compulsory in life, variable life, maturity is elective.
140. then trouble, do not forget to smile; no matter how tough, do not forget to adhere to; No matter how tired, but also love yourself.
141. the love in her heart is the worst savings methods can not give birth to interest, as you sent me warm.
142. foundation to mask skin imperfections, the soul smile to mask the wound.
143. \
144. you are lucky, because you can choose to love me or not love me; and I can only choose to love you or love you more.
145. I could one day fall in love with you, but the whole life time to forget you!
146. planted a city, and shut all the lights.
147. your sunset, my face, who's third year.
148. swaying in the tip of the dance, is the most intense spotlight touch of red.
149. I watched the sunset by the sea, clinging to a dream life of the pillow, You can not learn to let go but could not recall,belstaff jacket, how to go.
150. with a match and burned a mirage, by the heavy rain for their escape.
151. hide a hopeless street, smile penetrated it back.
152. eyelash injury under the landscape of the city who passed who's heart.
153. When the light out of silence language, you had a buy shop, and so to the Forgotten Cape sky.
154. witch's spell Happening kissed come pouring oath Luk Luk wet exit, I sat in the sea make up a network, you volt daytime singing in the sea.
155. swimming a world of a life and death.
156. your palm lines of gorgeous erotic tangle into the city who in the laughter.
157. written in a hope to the legends of love, then you will not endure the blazing ground went from ice and snow.
158. our story has been weathered carved in the mountain wall, passers-by saw them crying.
159. Who are you dreaming of the pen youth, in absolute shortage of pedestrians in the city was removed into a song.
160. by a thousand years to love you, and then a years time to forget.
161. who tears his eyes red mole sake of the prosperity of your I, your gift armored cavalry in the country who is a stone breaking shaking empty joy.
162. the next life of love songs, the words referred to you to fill in, see if you're still the king who is superior.
163. window array of full bloom is off the Love Fu Sheng and Xu-xu brilliance.
164. that love song about love affair, but nothing you and me.
165. Meijuan flowery, but also no match for Homecoming.
166. passing scenery, there is no one you have a good collection.
167. my memories of snow in the blazing sky, and you have a dictionary in which interpretation of conversion.
168. painted a wide lease of life and death game, for us to write a story ending.
169. Ireland snow, Turkish Blue, Moscow tears. I have a small sun, in the collection, as well as sunny days and smiles. Persian Gulf sea, Vienna Office, Arabic legend. I mark set in the thick of the phase. There are seven pink and princesses.
170. to cover up sadness perfectly.
171. Who sang from the song, to whom love, then, to whom to write horizon.
172. who does not pretend to be sad with a smile.
173. the drunk tomorrow lies in the Pandora's strings, floating rest of his life hypocritically singing heaven on earth.
174. is a sad fate, or the reincarnation of the pain.
175. Who Love who went from the End of the World.
176. Spirit of a fleeting time that we abandon the lonely wounded beyond recognition.
177. lonely so much in the exposure to a few.
178. Who Who's beautiful panoramic view, and who identify with the who's sad.
179. have not told you that I love is the same faith, have I told you love is always a person in mind.
180. like the song, quietly listening. Like people, much of the look.
181. the process and outcomes have it all, again entangled, even their own feel greedy.
182. sad asked for it, happiness is that you give.
183. cold-blooded woman, the heart must be cold.
184. hold that the Parti panic and disaster, is no match for the entire life of illusion.
185. If there is a pair of eyes to my tears, I would like to once again believe that this sad life.
186. the stars of the story is with you walking in a sea, do not let you get lost.
187. palate stranded wonderful vine is like a song you dance the last Empress Dowager.
188. multifarious experiences deep lines etched in the corner, I turned and carved the next flower.
189. my hand to sing, you play the Chopin, but my blind eyes.
190. I have wandered so long,belstaff online, do not want to go home, because you are not at home, I will never be home.
191. those entangled in the scandal into the night I'm not afraid to let you hear, but also not afraid to let the world hear. I was afraid you hear and believe.
192. As long as the hearts of the King, where the full path is not a flower.
193. those who refused to put on a lively curtain call out of one end of time Love in the flower.
194. next life I'll have another pawn, next life I come with you drink blood for the Union.
195. love you, give you all my life better, and then exit, so that brilliant kaleidoscope of your eye pupil.
196. rose out of the flower is not fragrant, miss one, miss the period of injury, do not cry, do not speak.
197. always doing two things repeated, love him and the guard.
198. Hush, my injury just fall asleep.
199. only for him to give up a city, when the day shone, went to a life or death, or unknown.
200. I want to see a big fall in the process of popular, I have kept a vow to promise to the marshes near you smile until changing the face of clear light.
201. Love missed out in the desert north of colorful crape myrtle flowers, but deserted the reincarnation of the spring and summer.
202. how much you walk the street, think of how many times I do.
203. repeated himself, and repeated concessions, in return for a feast on the lies

204. I put all the hurt go again, the sad thing is that you do not end. I go over all the despair, the most desperate are you still a starting point.
205. These days, who is not a mask with a box to wander?
206. I'm just sad I will not accompany you to the old, no opportunity to see your smile.
207. you and I strangers meet is a grace.
208. I hope,belstaff leather, in a scenic corner, I met you, and then met my own ...
209. so love yourself, it is difficult love
210. love, just an ideal
211. online dating is only love, but they can not spend the situation
212. a woman, do not give a man a lot of tolerance
213. Thank you stood in my life
214. to love, we only have this life
215. love, this should be a pleasure to do
216. I am not a change of heart, is not love
217. just in your arms, raising a happy hurt
218. We are all in love Chameleon
219. I like to love deeply keeping everything
220. lonely, I feel your good
221. past love affair, and resist the liberal frankly finished?
222. My love do not need to show
223. If you love, do not let me wait
224. you do not understand me, I do not blame you
225. There is a addictive addiction called loneliness
226. Can it be that one day we love each other
227. I love you, but I love you?
228. guarding the loneliness is to wait for love
229. \
230. love you, I open his own
231. well, not just love each other so simple
232. love, please do not say you're sorry
233. some love to let go, and you can see
234. rugged road conditions, please do not hand slowly
235. away from the love of money, when recently the furthest
236. forget it more difficult than to love a person
237. like you, from the deepest bottom of my heart
238. miss, is a pretty sad
239. I unknowingly lost the love
240. I love exists only for you
241. I miss you, stay at your fingertips
242. corner to meet love, do not corner the future
243. Because I love you, so willing to accommodate you
244. Love is like a speckled sugar crystals of arsenic
245. our love, has quietly gone away
246. in the light the pain turned to love with travel
247. lost hope, to let him go free
248. Do not forget to love when we promise
249. love will all become willing to
250. love you when is when?
251. love you, but do not ever go near you
252. Do not smoke in your hand as a woman
253. love you, I hold back the jealousy let you fly
254. We love other people too early, too late for love of their own
255. more afraid of hurting, the more to love
256. Love to the lure and then to separation from care
257. If I had known, I would not let go
258. It turned out that love has been and bystanders about
259. Love does not wait for you to cherish the time before
260. not free to hand, but do not easily let go
261. true love's name, called itself
262. the original romance was so quiet and silent
263. broke up with me to stop playing ambiguous
264. without you, my heart has been in the winter
265. Please do not break up the time on my tender
266. The only take away is that your habits
267. woman's ambiguous man not afford
268. Because I love you, so willful to you
269. love you, but I did not make good love you
270. I know, but you love in different ways
271. my heart, always of no fixed abode
272. find love easy, looking for love \
273. do not a couple, they should not be friends
274. love, why always so hurt
275. If I had known, I would not let go
276. Love can really be deep, but not crazy
277. \
278. Love, who is happy to whom?
279. Not all of the pain has \
280. This time, I want to make yourself happy
281. his wife is the man most familiar with strangers
282. I remember does not mean you miss you
283. If you do not care, how can it hurt?
284. after you have love, happy?
285. forgotten first love, is a sin?
286. I worry that others will take it seriously ambiguous you
287. I do not understand ambiguous,belstaff uk, do not want vague
288. Let us love, then injuries
289. like you, I never change the subject
290. put love out, love to know back
291. I want to love, in fact you can give
292. I want to love is actually very simple
293. In fact, I already do not love you
294. love you, to \
295. miss a loved one, in fact, I
296. care about the romantic feeling is the best
297. there is no fate, why then holding on
298. Jiuqingfuran, really hard
299. ex-boyfriend, is a kind of very interesting things
300. he is very good, but I am not impressed
301. I just love, endless
302. love to say I'm sorry
303. just love it
304. man's heartless, woman hurt
305. waved goodbye, goodbye lonely
306. there is one thought, can not declare
307. Perhaps we are not suitable for
308. faint feeling of the most beautiful
309. can not get, is the most beautiful
310. love, can not receive signals
311. silence, a love of the two realms
312. Thank you, and then contact
313. because we are too young
314. There is a love is not called to let go, called the collection
315. love, from the beginning to share
316.'d rather complete Needless perfect
317. In fact, nothing can not let go of the
318. in this life, I miss you
319. love her not to have her
320. Honey, Please hold my hand
321. first to the last lover
322. to give up to pay homage to the past
323. If only love, I can not do
324. as long as the energy and love of people together
325. love, not pain no gain
326. love the wrong person, so what?
327. My tears only you know
328. a woman, you can love a man, but can not forget the love of their own
329. have a love, is the guardian of two trees
330. love: because of the simple, there is no burden
331. not dwell does not mean you do not love you

332. There is a feeling, can only take heart to feel

333. You're not the best, but I love you
334. because I'm not your girlfriend ... ...
335. for you are willing to do a million times
336. late at night, open your cell phone for whom?

337. There is a happy

338. love to the depths no grudge

339. holding hands is the heart of the girls will give pulled the

340. We are ambiguous, we do not belong together
341.'ve heard of love coming back

[ug2at5hh2jg]

,belstaff uk

| Back to logs list


this log from the phone Qzone,belstaff jackets outlet! Mobile Access z.qq.com,belstaff online, anytime,belstaff sale, anywhere recording my mood,belstaff coat! The service is free of the details come in>>

published cancel



| Back to logs list

[3xkfen5o3k5u]

Clerk Finance can be used. - Qzone log


| Back to logs list

Reprinted from 819898 at 5:10 p.m. on August 10, 2010 Read (loading. ..) Comments (0) Category: Personal Diary
Word trick:
one, enter the three \Third, enter the three \CHOOSE (WEEKDAY (I3, 2), \; show of the week
Excel common functions Daquan

1, ABS function
function name: ABS
main functions: the absolute value of the corresponding figures obtained.
using the format: ABS (number)
Parameter Description: number to be requested on behalf of the absolute value or reference cell.
Example: If cell B2 enter the formula: = ABS (A2), in both cell A2 enter a positive number (eg 100) or negative (eg -100), B2 in both show positive (eg 100).
to remind: If the number parameter is not numeric, but some characters (such as A, etc.), then the error value is returned B2 \
2, AND function
function name: AND
main functions: to return the logical value: if all parameters are the logical \logical \
using the format: AND (logical1, logical2, ...)
Parameter Description: Logical1, Logical2, Logical3 ... ...: the conditions to be tested, said the value or expression, up to the 30.
Example: enter the formula in cell C5: = AND (A5> = 60, B5> = 60), confirmed. If the C5 return TRUE, shows the value in A5 and B5 were greater than or equal to 60, if return FALSE, that the values in the A5 and B5 at least one of less than 60.
to remind: If you specify a logical condition parameter contains non-logical values, then the function returns the error value \
3, AVERAGE function
function name: AVERAGE
main functions: Find the arithmetic mean of all parameters.
using the format: AVERAGE (number1, number2, ... ...)
Parameter Description: number1, number2, ... ...: to request the reference value or the average cell (area), the parameter does not exceed 30.
Application examples: in B8 cells enter the formula: = AVERAGE (B7: D7, F7: H7,red wing work boots, 7,8), is confirmed, you can find the area B7 to D7, F7 to H7 area values and average of 7,8.
to remind: If the reference area contains \
4, COLUMN function
function name: COLUMN
main functions: display the column label reference value of the cell.
using the format: COLUMN (reference)
Parameter Description: reference to reference cell.
Application examples: In the cell C11 enter the formula: = COLUMN (B11), confirmation is displayed as 2 (the B column).
to remind: If cell B11 enter the formula: = COLUMN (), also shows that 2; with the corresponding label value and a return line of the function - ROW (reference).
5, CONCATENATE function
function name: CONCATENATE
main functions: the number of characters in text or data in a cell together, displayed in a cell.
using the format: CONCATENATE (Text1, Text ... ...)
Parameter Description: Text1, Text2 ... ... the need to connect the characters of text or reference cell.
Application examples: In the cell C14 enter the formula: = CONCATENATE (A14 ,\characters and. com connection as a whole, appears in cell C14.
to remind: If the argument is not a reference cell, and the text format, please give the English state parameters with double quotes, if you change the formula: = A14 &\. com \
6, COUNTIF function
function name: COUNTIF
main features: a range of cells that meet specified statistical criteria the number of cells.
using the format: COUNTIF (Range, Criteria)
Parameter Description: Range on behalf of a range of cells to statistics; Criteria that specify the conditional expression.
Application examples: In the cell C17 enter the formula: = COUNTIF (B1: B13, \the number of cells.
remind: to allow a range of cells referenced in the blank cells appear.
7, DATE function
function name: DATE
main functions: the values given in the specified date.
using the format: DATE (year, month, day)
Parameter Description: year value for the specified year (less than 9999); month for a specified number of months (can be greater than 12); day for a specified number of days .
Application examples: In the cell C20 enter the formula: = DATE (2003,13,35), confirmation, show 2004-2-4.
reminded: As the above formula, the month is 13, more than a month, postponed to January 2004; 35 days, compared with January 2004 the actual number of days the addition of 4 days, it is also extended to 2004 on February 4.
8, the function name: DATEDIF
main functions: calculate the difference between returns two date parameters.
using the format: = DATEDIF (date1, date2, \a date, date2 on behalf of a date later; y (m, d) asked to return to the annual difference between the two dates (month, day) number.
Application examples: In the cell C23 enter the formula: = DATEDIF (A23, TODAY (), \, and returns the number of years difference.
reminded: This is a hidden function in Excel, is found in the Function Wizard, you can use direct input for the calculation of age, length of service and so very effective.
9, DAY function
function name: DAY
main functions: Find the reference to a specified date or the date the cell number of days.
using the format: DAY (serial_number)
Parameter Description: serial_number on behalf of the specified date or reference cell.
Example: enter the formula: = DAY (\
to remind: If the given date, include double quotation marks in English.
10, DCOUNT function
function name: DCOUNT
main functions: to return a database or list of columns to meet the specified conditions and the number of cells that contain numbers.
using the format: DCOUNT (database, field, criteria)
Parameter Description: Database statistics said the need for a range of cells; Field said that the data used in the function list (must be marks on the first line item); Criteria include Conditions range of cells.
Application examples: Figure 1 shows, in cell F4, enter the formula: = DCOUNT (A1: D11, \or equal to 70, while the value is less than 80 the number of cells (equivalent to the number of fractional section).

to remind: If you modify the above formula: = DCOUNT (A1: D11,, F1: G2), can also achieve the same purpose.
11, FREQUENCY function
function name: FREQUENCY
main functions: to return to a vertical array of data in an area frequency distribution.
using the format: FREQUENCY (data_array, bins_array)
Parameter Description: Data_array that used to calculate the frequency of a set of data or range of cells; Bins_array that separated the front of an array of values.
Application examples: as shown in Figure 2, while selected range of cells B32 to B36, enter the formula: = FREQUENCY (B2: B31, D2: D36), enter the complete press \key to confirm, you can find the B2 to the B31 area, according to D2 to D36 region separated values of the frequency of the number of segments (equivalent to the number of statistical segments of the score).

reminded: The input is an array formula, you're finished, you need to by pressing \({}), the braces can not be directly input.
12, IF function
function name: IF
main functions: According to the logic of the conditions specified in the true and false results, return the corresponding content.
using the format: = IF (Logical, Value_if_true, Value_if_false)
Parameter Description: Logical representative of logic expressions; Value_if_true that determine the conditions when the logical \TRUE \
Application examples: In the cell C29 enter the formula: = IF (C26> = 18, \the C29 cell displays \
remind: this article, similar to the \the corresponding cell, please refer to the specific instance of the file attached.
13, INDEX function
function name: INDEX
main functions: to return a list or array element value, this element by the row number and column number of the index values determined.
using the format: INDEX (array, row_num, column_num)
Parameter Description: Array on behalf of a range of cells or an array constant; Row_num that the specified line number (if omitted row_num, there must be column_num); Column_num that the specified column number (if omitted column_num, you must have row_num).
Application Example: Figure 3 shows, the F8 cell enter the formula: = INDEX (A1: D11, 4,3), confirmed the show range of cells A1 to D11, the first 4 rows and the intersection of three cells (ie, C4) in the content.

remind: line number argument here (row_num) and column number parameter (column_num) is relative to the terms of reference of the range of cells, not Excel worksheet rows or columns in the sequence number.
14, INT function
function name: INT
main functions: the value rounded down to the nearest integer.
using the format: INT (number)
Parameter Description: number expressed the need for rounding numeric values or include a reference cell.
Example: enter the formula: = INT (18.89), confirmation shows 18.
remind: when in the rounded, without rounding; If you enter the formula = INT (-18.89), the result is returned to -19.

15, ISERROR function
function name: ISERROR
main functions: to test the functional return value for errors. If wrong, the function returns TRUE, otherwise returns FALSE.
using the format: ISERROR (value)
Parameter Description: Value that need to test the value or expression.
Example: enter the formula: = ISERROR (A35/B35), confirmation, if the B35 cell is empty or \
reminded: This function is usually associated with supporting the use of IF functions, if you modify the formula: = IF (ISERROR (A35/B35 ),\the cell appears empty, otherwise display A35/B35
results.
16, LEFT function
function name: LEFT
main functions: a text string from the first character, the interception of a specified number of characters.
using the format: LEFT (text, num_chars)
Parameter Description: text representative of the character string to be cut; num_chars interception of a given number of representatives.
Application example: assume that the cell holds the A38 \characters.
reminded: This function name in English means \
17, LEN function
function name: LEN
main functions: the number of characters in text string Statistics.
using the format: LEN (text)
Parameter Description: text, said text string to statistics.
Application example: assume that the cell holds the A41 \
reminded: LEN to statistics, whether in full-width characters, or half-width characters, each character are counted as \\
18, MATCH function
function name: MATCH
main functions: to return in the specified manner that matches the specified value of the corresponding elements in the array position.
using the format: MATCH (lookup_value, lookup_array, match_type)
Parameter Description: Lookup_value representatives need to look at the data sheet value;
Lookup_array that may contain the values you want to find a continuous range of cells;
Match_type find the way that the value of (-1,0 or 1).
match_type to -1 if, find the smallest greater than or equal to lookup_value value, Lookup_array must be in descending order;
If match_type to 1, less than or equal to lookup_value find the maximum value, Lookup_array must be sorted in ascending order ;
If match_type 0, find the first value is equal to lookup_value, Lookup_array can be arranged in any order; If omitted match_type, the default is 1.
Application examples: Figure 4 shows, in cell F2 enter the formula: = MATCH (E2, B1: B11, 0), confirmed the results returned to find \

reminded: Lookup_array can only be one column or row.
19, MAX function
function name: MAX
main functions: Find the maximum value in a set of numbers.
using the format: MAX (number1, number2 ... ...)
Parameter Description: number1, number2 ... ... representatives to request the maximum value or a reference cell (area), the parameter does not exceed 30.
Example: enter the formula: = MAX (E44: J44, 7,8,9,10), confirmed to display the E44 to the J44 cells and in the region and the maximum value 7,8,9,10 .
to remind: If the parameters are text or logical values, is ignored.
20, MID function
function name: MID
main functions: a text string from the specified position, and the interception of a specified number of characters.
using the format: MID (text, start_num, num_chars)
Parameter Description: text represents a text string; start_num that specifies the starting position; num_chars that number to be intercepted.
Application example: assume that the cell holds the A47 \\
remind: the formula of the parameters, use the English state of the comma \
21, MIN function
function name: MIN
main functions: Find the minimum value in a set of numbers.
using the format: MIN (number1, number2 ... ...)
Parameter Description: number1, number2 ... ... representatives to request the minimum value or a reference cell (area), the parameter does not exceed 30.
Example: enter the formula: = MIN (E44: J44, 7,8,9,10),red wing heritage boots, confirmed to display the E44 to the J44 cells and in the region and the minimum values 7,8,9,10 .
to remind: If the parameters are text or logical values, is ignored.
22, MOD function
function name: MOD
main functions: Find the remainder of dividing two numbers.
using the format: MOD (number, divisor)
Parameter Description: number representative of the dividend; divisor on behalf of the divisor.
Example: enter the formula: = MOD (13,4), confirmed the results show that \
to remind: If the divisor parameter is zero, then the error value \.
23, MONTH function
function name: MONTH
main functions: Find the reference to a specified date or the date cell of the month.
using the format: MONTH (serial_number)
Parameter Description: serial_number on behalf of the specified date, or reference cell.
Example: enter the formula: = MONTH (\
to remind: If the given date, include double quotation marks in English; if you modify the formula: = YEAR (\
24, NOW function
function name: NOW
main functions: given the current system date and time.
using the format: NOW ()
Parameter Description: This function takes no arguments.
Example: enter the formula: = NOW (), immediately after confirmation showing the current system date and time. If the system date and time changed, just click the F9 function key, you can let it change.
reminded: display the date and time format, you can re-set the cell formatting.
25, OR function
function name: OR
main functions: to return a logical value, only if all parameter values are logical \Otherwise, return a logical \
using the format: OR (logical1, logical2, ...)
Parameter Description: Logical1, Logical2, Logical3 ... ...: the conditions to be tested, said the value or expression, up to the 30.
Application examples: In the cell C62 enter the formula: = OR (A62> = 60, B62> = 60), confirmed. If C62 is returned TRUE, A62 and B62 in that at least one value greater than or equal to 60, if the return FALSE, that the values in A62 and B62 are less than 60.
to remind: If you specify a logical condition parameter contains non-logical values, then the function returns the error value \
26, RANK function
function name: RANK
main functions: to return a numeric value in a column in the ranking relative to other values.
using the format: RANK (Number, ref, order)
Parameter Description: Number values to sort the representative; ref numerical order in which the representatives of a range of cells; order on behalf of sort parameters (if it is \ignored, according ranked in descending order, the larger the number, the smaller the value of ranking results; if non-\
Example: If cell C2 enter the formula: = RANK (B2, $ B $ 2: $ B $ 31,0), D 1 can be derived after confirmation of language students in his class ranking in the results results.
remind: In the above formula, we let the Number parameter to a relative reference to the form, and let the ref parameter to the absolute reference in the form (adding a \mouse over the lower right corner of the cell, into thin cross-linear (usually called the \complete ranking scores of other students language statistics.
27, RIGHT function
function name: RIGHT
main functions: a text string from the last character in the beginning, the interception of a specified number of characters.
using the format: RIGHT (text, num_chars)
Parameter Description: text representative of the character string to be cut; num_chars interception of a given number of representatives.
Application example: assume that the cell holds the A65 \characters.
reminded: Num_chars parameter must be greater than or equal to 0, if omitted, the default it is 1; num_chars parameter is greater than if the length of the text, the function returns the entire text.
28, SUBTOTAL function
function name: SUBTOTAL
main functions: to return a list or database subtotals.
using the format: SUBTOTAL (function_num, ref1, ref2, ...)
Parameter Description: Function_num 1 to 11 (includes hidden values) or 101-111 (ignores hidden values) between the figures for What is the function specified in the list with subtotals calculated (Figure 6); ref1, ref2, ... ... on behalf of regional or subtotals to be a reference to not more than 29.
Application examples: as shown in Figure 7, the cells in the B64 and C64, respectively, enter the formula: = SUBTOTAL (3, C2: C63) and = SUBTOTAL103, C2: C63), and will hide the line 61, after confirmation The former appear as 62 (including the hidden rows), which appears as 61, not including the hidden rows.


to remind: If you take automated screening, no matter what type function_num parameters are chosen, SUBTOTAL function ignores any screening results are not included in the line; SUBTOTAL function is applied to the data columns or vertical area, does not apply to row or level area.
29, the function name: SUM
main functions: the calculation of all parameters and values.
using the format: SUM (Number1, Number2 ... ...)
Parameter Description: Number1, Number2 ... ... need to calculate the representative value may be a specific value, a reference cell (area), logical values and so on.
Application examples: as shown in Figure 7, in the cell D64 enter the formula: = SUM (D2: D63), confirmed the language of the score can be calculated.
to remind: If the argument is an array or reference, only one of the numbers will be calculated. Blank the array or reference cells, logical values, text or error values are ignored; if you modify the formula: = SUM (LARGE (D2: D63, {1,2,3,4,5})), you can find the top 5 results and.
30, SUMIF function
function name: SUMIF
main functions: to meet specified conditions for calculating the value and the range of cells.
using the format: SUMIF (Range, Criteria, Sum_Range)
Parameter Description: Range to determine the range of cells representative of conditions; Criteria for the specified conditional expression; Sum_Range need to calculate the value representative of where the range of cells.
Application examples: as shown in Figure 7,red wing heritage boot, in the cell D64 enter the formula: = SUMIF (C2: C63, \.
to remind: If you modify the above formula: = SUMIF (C2: C63, \Because it is text-based, needs to be placed under the English double quotes (\
31, TEXT function
function name: TEXT
main functions: the value specified format according to the corresponding number into text form.
using the format: TEXT (value, format_text)
Parameter Description: value to convert the value on behalf of or reference to the cell; format_text for the specified text in the form of digital format.
Example: If the B68 cell preservation values 1280.45, we enter the formula in cells C68: = TEXT (B68,red wing motorcycle boots, \
reminded: format_text parameters under the \
32, TODAY function
function name: TODAY
main functions: given the system date.
using the format: TODAY ()
Parameter Description: This function takes no arguments.
Example: enter the formula: = TODAY (), confirm that immediately after the system date and time display. If the system date and time changed, just click the F9 function key, you can let it change.
remind: the date format displayed, you can re-set the cell format (see annex).
33, VALUE function
function name: VALUE
main functions: the value of a text on behalf of the string is converted to numeric type.
using the format: VALUE (text)
Parameter Description: text-based representatives need to convert the text string value.
Example: If the B74 cell function is the interception by LEFT and other text-based strings, we enter the formula in cells C74: = VALUE (B74), confirmed, can be converted to numeric.
to remind: If the text type value is not a result of these conversions, the use of the function to deal with these values, often returns error.
34, VLOOKUP function
function name: VLOOKUP
main functions: the first column in the data table to find the specified value, and thus returns the current row in the table at the specified column value.
using the format: VLOOKUP (lookup_value, table_array, col_index_num, range_lookup)
Parameter Description: Lookup_value representatives need to find value; Table_array representatives need to find data in which the range of cells; Col_index_num in the region to be returned table_array match the value of the column number (when Col_index_num is 2, the return table_array values in column 2, 3, the return value of column 3 ... ...); Range_lookup is a logical value, if it is TRUE or omitted, the return approximate match, that is, if can not find an exact match, it returns the maximum value of less than lookup_value; If FALSE, it returns an exact match, if not, it returns the error value # N / A.
Application example: see Figure 7, we enter the formula in cell D65: = VLOOKUP (B65, B2: D63, 3, FALSE), confirmed, as long as the cell B65, enter a student's name (such as D 48), D65 cells showed immediate results of the student's language.
reminded: Lookup_value must Table_array see the first column of the region; if ignored Range_lookup parameters, Table_array the first column must be sorted; the Wizard in this function, the Range_lookup parameter usage is wrong.
35, WEEKDAY function
function name: WEEKDAY
main functions: the date given corresponds to the specified number of weeks.
using the format: WEEKDAY (serial_number, return_type)
Parameter Description: serial_number on behalf of the specified date or dates of that contains the cell references; return_type representation on behalf of weeks [when the Sunday (Sunday) to 1, Saturday (Saturday ) is 7, this parameter is 1; when Monday (Monday) 1, Sunday (Sunday) to 7, this parameter is 2 (this is in line with the Chinese habit of); when Monday (Monday) to 0 , Sunday (Sunday) to 6, this parameter is 3].
Example: enter the formula: = WEEKDAY (TODAY (), 2), confirm the system date is given after the number of weeks.
to remind: If the specified date, please put the English under the double quotes, such as = WEEKDAY (\
one. Select a color effect to the cell form, format - conditional formatting, conditions, select the \


1. interlacing color effect (odd row colors):
= MOD (ROW (), 2) = 1
2. interlaced color effect (even row colors):
= MOD (ROW (), 2) = 0
3. If you want to set the format for each application of a shading line 3, you can use the formula:
= MOD (ROW (), 3) = 1
4. If you want to set different odd and even column shading, as long as the formula of the ROW () to COLUMN () can, such as:
= MOD (COLUMN (), 2)
5. If you want to set chess checkerboard shading (white + custom color):
= MOD (ROW () + COLUMN (), 2)
Description: The conditional formatting formula used to determine the line number and column number and the remainder is divided by 2 to 0. If 0, indicating the number of rows and columns of the same parity, then fill the cell to the specified color, or not filled. In the conditional formatting, the formula results to return a number, non-0 numbers is the TRUE, 0, and the error value is FALSE. Therefore, the above formula can be written as:
= MOD (ROW () + COLUMN (), 2) 0
6. If you want to set the chess checkerboard shading (custom colors + custom color):
add style 2:
= MOD (ROW () + COLUMN (), 2) = 0
II. Color filter can
excel2007 cell color,red wing mens boots, font color or icon to be sorted.
If excel2003, need to add auxiliary column, the name of the method defined by the color of the corresponding number, then the secondary sort column:
color cell in column A, select B1, Insert -> Name - > definition, input a, input the following formula = get.cell (24, $ a1),
this method get the serial number of the font color. B1 enter = a copy the formula down to the appropriate line.
the full table can be sorted by column B. If want to get the background color of the serial number will be changed to 63 to 24.
== \into the name to use
2.Get.Cell (Num, Cell) is the function of the form, Get.Cell can get a cell in a variety of information, such as frame format, etc., Num is specified to obtain the kind of information, 24 out this function is to let the color information unit, taken out after a 1-56 number to represent color number
3. B1 column if you enter your name and fill out the definition, then A1 B1 in the figure is the color code, B2 is A2 in the figure will be the color code, and so
4. Now you press the B column sort, in fact, according to color sort column A the.
attached Get.Cell the meaning of each parameter:
1 refer to the absolute address cell reference cells
2 No.
3 column reference column number cell similar
4 TYPE function
5 with reference to the text contents of the address
6 shows the light formula
7 with reference to the address format of the address, text display text display
8 format
9 with reference to the address to return extra storage box left style, figures show
10 extra storage box on the right to return the style, the figures show
11 store extra return on the style side box, digital display
12 frame side return the extra storage under the style, number of Show
13 returns the internal drawings, figures show
14 locked if the cell is set to return True
15 is hidden if the formula returns True
16
returns the width of the cell 17 points as the unit returned to the cell height
18 point font name
19 to return the font size for the unit cell all
20 or if a character is bold return True
21 If all or a cell in italics the first character returns True
22 If all or a cell first character is a single bottom line returns True
23 if the cell or the first characters of all the middle of a horizontal line font Returns True
24 returns the first character color cell number, 1 to 56. If set to automatic, returns 0
25 MS Excel does not support the outline format
26 MS Excel format does not support the shadow figures
27 insert page breaks manually set the outline of the column
28 Outline of the field-level
29
30 if the level of the outline summary of the range compared to True
31 if the range is the outline of the summary column was True
32 shows the workbook and worksheet name of the
33 If the cell formatting for multiple lines of text compared to True
34 extra storage box on the left to return the color, figures show. If set to automatic, returns 0
35 extra storage box on the right to return the color, figures show. If set to automatic, returns 0
36 extra storage box at the top to return color, figures show. If set to automatic, returns 0
37 return save extra box below the color, figures show. If set to automatic, returns 0
38 cells future returns shadow colors,red wing heritage, figures show. If set to automatic, returns 0
39 returns the cell back shadow color, figures show. If set to automatic, returns 0
40 text display cell style
41 returns the address of the original equation reference
42 points as the unit returned to the use of the left window on the left to the level of cell Distance
43 in points in the top of the window to return to using the cell above the vertical distance
44 in points in the window on the left to return to the use of a cell to the right of the horizontal distance
45 points unit returns to the top of the window used in the cell below the vertical distance
46 are inserted comments if the cell returns True
47 if the cell has to insert a sound prompt return True
48 are inserted into the formula if cell Returns True
49 if the cell is an array formula returns the range of returns True
50 cell vertical alignment, the figures show
51 perpendicular to the direction of the cell returned, figures show
52 pass back to the cell prefix character
53 text display shows the contents of the cell returned
54 returns the name of the PivotTable cell
55 returns the cell in the PivotTable pivot position
56
57 If all or a cell first character is superscript text return True
58 shows return of all or a cell font style
59 characters return the cell bottom line style, the figures show
60 If all or a cell for the first character subscript returns True
61 pivot
62 shows the workbook and worksheet name
63 returns the fill color of a cell mass
64 Back to the drawing foreground color
65 pivot
66 shows the workbook name

[ug6bt0zh4cg]

| Back to logs list

2126141 2010 年 06 月 18 日 11:06 Reading (loading. ..) Comments (0) Category: Personal Diary
the beginning of dollars articles

Sun Zi said:
soldiers who affairs of state of life and death, the survival of the Road, must be aware also.
it to five by the matter of school to take account of, and claims the situation: one said channel, second is days, the third is, the Si Yue will be the five
said method. Tao, so that people in the last agreed to die with them, with which students can not risk him; days are the yin and yang, cold and heat
, when the system has; to those near and far, risks Yi, Guang Xia, and death also; the person, intellect, faith, benevolence, courage, strict also; method
those music system, the Guan Dao, the main use it. Where this five, they will be heard all working, knowledge of who wins, I do not know the person victorious. Therefore, the school
of the total, while the index of their situation, saying: Lord what proper way? There will be what? What was heaven and earth? Order what line? Strong public what soldiers?
his soldiers what to practice? What out rewards and punishments? I know the outcome of this carry on. Will listen to my count, with the win, leaving them; will not listen to my account
, doomed to failure used to it.
total interest to listen to, is worth the potential to rank and file out of it. And powerful, has the right to take advantage of the system. Soldiers who deception too. It could be said of
and can not, do not use the show of the past and show the far, far and show the close. The lure of profits, chaos and taken from, real
the preparation of, strong without fear, anger and scratch it, humble and proud of, lost the labor of, and away from the parent, focusing on non-prepared, out of its
unexpectedly. The military commander of victory, not the first pass also.
husband did not fight the winner of the temple operator may also count more; not count numerous battle of the temple, who was considered too small. Less multi-operator wins count,
and conditions with no operator peace! I this perspective, the outcome see the carry on.

grandson said operational Posts

:
where military forces of the law, Autopia thousands Si, Ge Qian Cheng car, with a hundred thousand, a thousand miles fed grain. The inside and outside of the fee, guests
use, plastic paint the material, the instructions from a vehicle, at fees daughter, and then hundreds of thousands of teachers held carry on.
use of warfare, victory is a long sharp blunt military setbacks, siege, the force bent, long division, the country with the lack of violence. Sharp blunt soldiers frustrated husband,
flexor force exhaust goods, then the princes by disadvantages into the sky, though the wise can not be good then carry on. So Wen Zhuo Bing-speed, long
not see too clever. Fu Bing Lee long and the country who are also not of. Therefore, not the military forces of the victims know, you can not make use of forces of interest to know also.

use of soldiers who served no nationality, no three-contained food, take for the country, because of grain on the enemy, so the military can be enough food also.
Poor country lost on the teachers are far, far lost the poor people; nearly teachers are Guimai, Guimai the people of wealth have dried up, dried up the rush hill fiscal reserve.
force bent the Central Plains, the virtual at home, the people of the fee, ten to the seven; public of the charges, the military strike breaking horses, armor arrow bow and halberd, spear and shield
Lu, Qiu cattle carts, ten to the VI. Therefore, food services in Chile will be the enemy, the enemy eating a bell, when I twenty minutes; □ ① bar
one stone, when my twenty stone. Therefore, those fighting the enemy, angry also; take the enemy's interests are, cargo also. Car wars may take more than ten vehicles, tours and more
the basis of their flags are. Hybrid cars and ride it, and keep the good soldier, while the benefits are strong that the enemy wins.
so precious in wins, not expensive for a long time.
refresher soldiers will, the people of the Siming. National security of the Lord.

【Note:】
①: \

plan of attack articles

Sun Zi said:
husband military forces of the law, the country is on the second break the country; army is on breaking the military, followed by; the whole trip is on
break the trip; death is on the whole, broken, followed by death; the whole Wu is on break, followed by Wu.
Therefore in victorious, not good to do good; the enemy without fighting the soldiers, the good and good also. Therefore, the Bing Fa Mou,
times its cross-cutting, followed by cutting forces, under siege. Siege of the law, as a last resort. Xiu Lu □ ① □ ②, with equipment, three months and then into
; from the mound, and then in March has been. Ants to cope with their anger and attached, to kill his soldiers one third of the city who do not
pull this attack of the disaster also. Gushan use of troops who subdue the enemy rather than warfare, rather than attack the city of pulling people have ruined the country and not for a long time
person also, shall be in full competition in the world, so the soldiers can not Washington and Lee all, The law also seek for the attack.
so military forces of the law, ten Wai, five for the attack, fold the points, you can fight the enemy, at least able to escape it, if you can not
avoided. Therefore, the small firm the enemy, the enemy of the capture also.
husband will who also assisted country. Fu Zhou Zeguo will be strong, auxiliary gap, the country will be weak. Gu Jun in the military who suffered third reason:
I do not know the military can not turn into that of, I do not know that the military should not retreat the retreat, is that the Mi Army; I do not know the three services of the armed forces of the same things and
governance, the sergeant carry confusion; I do not know the three services of the armed forces of any of the same right, the sergeant doubt carry on.
Confusion and doubt both armed, the princes of the hard Zhiyi. Is that the victory for creating chaos.
refresher win five: knowledge can not fight war with who wins, use knowledge Zhonggua wins, wins up and down with the desire to be unexpected
Yu wins, will win the monarch did not Yuzhe . The five who also know the road win. Hence we say: Know thyself
not battle-Yi; I do not know he and close friend, and one win and one loss; I do not know he is not friends, no win every battle.

【Note:】
①: [car Ben].
②: \

shaped articles

Sun Zi said:
past the warriors who can not be the first to win, to be the enemy to win. Can not win in himself, can win the enemy. So skillfully are
, can not win, can not make the enemy will win. Hence it is: win shows, but impractical. Not the winner, keep also;
be the winner, attack also. Code deficiencies, are more than attack. Good to keep those hidden in the under nine, good attack were fixed in nine days on
, it can protect themselves and the victory also. See win, but you all know, the good and not too good; over the world said good, the good and non-
good also. Not to give it more power in autumn, see the sun and the moon is not as eyesight, smell is not for the ears and Thunder. The so-called good old war who
, easily better than the winner also. Therefore, the wins and skilled persons also, lack of wisdom were, no courage power,belstaff leather, so the defeat is not Intuit. Intuit who do not
, it measures wins, wins have been losers as well. So skillfully are invincible, and yet the enemy also lost. Victorious soldiers
Qiuzhan first victory and then, while defeated warriors go to war first and then to win. Use of soldiers who cultivate and Protection Law, it is for victory or defeat of the government.
art of war: one said degree, second is the amount, third is the number of Si Yue said Wu Yue wins. Degrees to students, du volume, the amount of raw numbers
, the number of students that said the students win. Peter said if it wins soldiers baht, while defeated warriors go if baht, said Yi.
people also said the war winner, if the decision a thousand yards of the river water in those shapes too.

potential of

Sun Tzu said:
few who rule the public, such as governance, scores is also; Doo Doo the public, such as few, form name is also; the three services of the public, will be the enemy can The
no losers, it is also odd; soldiers are added, such as the egg □ ① vote who is also the actual situation.
any war who, in exact order Clipsal. Gushan who surprisingly, infinite as heaven and earth, inexhaustible as Jianghai. Undone before the end
, sun and the moon is also. Rehabilitation death seasons is also. Sound only five, five sound of the change, and hearing they can not win; colors, but Five
, five colors of the change, can not win concept also; taste, but five flavors of the change, can not win try also; the military situation is surprising, however, odd
is the change, can not win the poor also. Qi is with students, such as the cycle of no reason, Practice makes the poor of the holy!
bowel disease of water, as those boulders, potential also; the fowls of the disease, as to destroy off those sections also. So skillfully, their
potential risks, the section is short. Such as the potential expansion of crossbow, sections such as hair dryer. Have Yunyun, chaos and can not fight chaos; muddy chaos chaotic, round-shaped and can not defeat
. Born in chaos rule, was born in Yong cowardly, weak, born strong. Combat confusion, a few are; courage of confidence, the potential also; strength, shape
also.
Gushan moving enemy who, in the form of the enemy from God; to it, the enemy will take it. To facilitate moving to finally be it. Gushan
war who help of trend momentum, it is not responsible for the human person can choose any situation. Any potential, their war people, such as wood and stone transfer. The nature of wood and stone
, Anze Jing, risk is dynamic, square is only round the line.
so skillful trend of people, such as genetically boulders on the mountain were a thousand yards, the potential also.

actual situation Posts

Sun Tzu said:
who asked to be the enemy who at the field and Lost, while the trend after the war were at the field of labor. So skillfully are, cause they would not people. Since the enemy to those who can
, Lee Chih; make the enemy not to persons, victims of too. Lost it to workers of the enemy, full of energy hungry
, the dynamic of security. That it will be increasingly, increasingly it unexpectedly.
traveling thousands of miles without the workers who is also the line in the no man's land; attack and will take those attacks do not keep it too. And who will be solid defensive
, they will keep attacking as well. Gushan attacker, the enemy did not know they keep; good keepers, I do not know their enemy attack. Almost almost micro-micro,
As for the invisible; God from God almost, as silent, and it could be an enemy of the Siming. Then not Yuzhe, red is also the virtual; back
and can not recover those, and also speed and can not. So I want to fight the enemy, while high barrier deep groove, who had to fight with me, attack their
will save him; I do not want war, although the painting to keep the enemy who can not fight with me, it s good also. It shaped who I am without
shape, I designed the enemy points. I for one, the enemy is divided into ten, ten is one attack too. Public enemy is my widow, able to hit all
few persons, the passions, which were about carry on with the war. Wu Suo and combat land unknown, unknown who is the enemy of the equipment more than the enemy who are more prepared
, the Wusuo carry on with the war are few. Therefore, the latter prepared by former scarcity, for later in the preceding few, few on left then the right, the right equipment is left
few, nothing is prepared, no do not widowed. Few persons, who were also prepared; all those people who have been prepared. Land warfare refresher
, know the day of battle, the battle may be thousands of miles; I do not know the land of war, I do not know war days, you can not save the right of left and right can not save
left, the former can not be saved, the post can not save before, and conditions were far from dozens of years, recently, a few years almost!
to my degree, the more the soldiers, although many also benefit from the win Zai Xi!
twenty years before: win can be also. Although the public enemy, can not fight. Therefore, the plan for making the conceivable gains and losses, with knowledge of the movement of
designate management, the conceivable form of life and death, the angle makes me know more than weaknesses. Therefore, the extreme form of soldiers, as invisible. Between the invisible dark can not glimpse the
, the wise man does not seek. Shape and measures rather than by the public, the public can not know. I so win who knows that the shape, and so I
Mozhi Winning form. So the beat no longer, but should be shaped in the endless. Fu Bing
image of water, avoid the high water line of trend, the soldiers hit form to avoid the real and imaginary; water flow due to the system, soldiers and victory for the enemy
. Therefore, the potential impermanence soldiers, the water is uncertain shape. Can change because of the enemy to win those, that the God. Therefore, the five elements becomes a Buddha,
pm uncertain position, long or short day, month, a life and death.

military struggle articles

Sun Tzu said:
where the military forces of the law, the orders from the king, gathered together the military, diplomacy and the homes, Mo difficult military struggle. The difficulty of the military who fight,
to migrate straight to suffer into an advantage. migrate its way
it, and entice the benefit of others and hair, their ancestors to this the plan for those who know Yuzhi also. Order to facilitate the military struggle, the military struggle for the crisis
. Give the military and not for profit and the appointment of army and baggage for profit is donated. Therefore in the paper a trend, not at night, times
Road and the line, Barry and for profit, then capture three generals, fresh, first, exhausted by, its law and to the eleven; fifty in the competition
Lee,belstaff outlet, you stumble on the general, half to the law; ten miles and a scramble for profits, the two-thirds to. Therefore in the military without baggage will die,
without food will die, no commissioned product will die. Princes of the plan so I do not know who can not pay Yu; I do not know the mountains, obstacles, Ju Ze
of shape, can not march; not township guide who can not get location. Therefore, in order to soldiers fraud legislation to facilitate the move to those points and also for the change
. Therefore, its lightning-fast winds, and their Xu Rulin, invaders like fire, do not move like a mountain, it is difficult to know, such as yin, moving as Lei Chen. Swept Township
divided, sub-profile to benefit, suspended the right moves. Prophet Yuzhi the total wins, the military struggle of the law also.
\Only specific people are not alone into the brave, cowardly retreat shall not alone in this with all the
law also. Therefore, multi-Ku night combat, day war more flags, so the eyes and ears were also changed.
army may seize gas, the generals can seize the heart. Therefore in sharp energetic, inert gas day, apathy return. Use of soldiers who, to avoid the sharp
gas, hit the idle return, the government gas among them. The rule to be arbitrary, to wait for Wow, who is also the heart of this rule. Nearly to be far away, to be Labour Lost
to eat until hunger, the government forces those who are. No invitation is precisely the flag, without imposing the hit Chen, who is also the rule change.
so military forces of the law, Gao Ling not to, do not back against the hill, pretend not from the north, Ruicu do not attack, bait Bing Wu Shi, in the final division not
containment,belstaff jackets outlet, confining Shiyi Que, tottering foe not to force, this military forces of the law also.

nine Pandemic

Sun Tzu said:
where the military forces of the law, the orders from the king, joint military polymerization. Pan to no homes, Qu to co-pay, no leave the Jedi, is seeking around to
, kill the war, the way has not help, the military has not hit, some do not attack the city, to be indisputable, Junming there The
not.
it will pass on the nine variables of interest who know military forces carry; will change the profit barrier nine, though know the terrain, can not get to carry on the benefits
; Zhibing I do not know the art of nine variables, although the five interest to know can not have people use carry on.
Therefore in the considered wise, will be mixed in the interest, miscellaneous and service credibility is also at the benefit, harm and suffering in hybrid can be separated. Therefore in order to harm those who bend
princes, princes who served in industry, the trend princes were to benefit. Therefore, military forces of the law, no it does not come to rely, rely
I have to treat it; not rely it does not attack, I have not attack relies too.
it will have five danger, death can be killed, is bound to produce to Krupp, the anger-speed can be insulted, and honest to shame, Oi can be annoying. Where this five
, they will be at fault also, military forces of the disaster also. Will cover the military to kill, will be a five-crisis, must be aware also.


march Posts

Sun Tzu said:
at the military phase where the enemy must Hill by Valley Health Department, as the high non-Teng Long War, where mountains of the Army . Water will never distant water,
water must come off, do not welcome is to the water within, so that crossing the strike of half-profits, like war, those with no attached to the water and welcoming, as the Health Department
high No welcome water, where water of the Army. Never denounced Ze, the only non-urgent to stay, if cross into the armed forces denounced Ze, but will be back by
plants the trees, where the Army Ze exclusion. Flat land is fragile, right back high before the death of Health, where flat land of the Army
. The above activities and benefit from the Fourth Army, Emperor Huangdi also the reason why four wins. Where the evil army under a good high, Guiyang and cheap Yin, and health while at the
fact, the military without a hundred diseases, is that win. Hilly embankment, while the right will be at the back of the sun, the soldiers of the benefits, to the help also.
on the water flow to, like those involved, let it be also. Where to have the absolute stream,belstaff jacket, patio, Tianlao, day Lo, the day depression, days gap,
will go to the urgent, not nearly as well. I distanced the enemy near them; I welcome it, the back of the enemy. Army next to obstacles, Huang wells Jianjia
, Kobayashi, □ ① Hui who will wish to cover the cable, the underlying evil of which are.
near the static enemy who relies on the Risks; far the challenger into the person want to have; they DrayTek who benefit also; all the trees
actors, to have; all the grass and more impaired suspicion of him; birds from those V also; beast hack who follow him; dust were high and sharp, the car
to him; base and wide who only come to him; scattered over the bar who also collected firewood; few and between those camps Army; speech Peel and prepare
who enter also; words were strong and into the drive, back also; light rail vehicles, first-out home of their side who, Chen also; not about the requested and who plan also
; running the Bing who, on him; half into a half back who lured him; stick standing who are hungry; drain first and drinker, thirsty also
; see the benefits rather than entrants, workers also; birds are sets, virtual also; night call who fear him; military interference, then it will not fall again; flags
actors, revolt; Officials anger, tired also; kill the horse meat eaters, the military without food also; hanging □ ② not return to their homes who tottering foe also
; earnest □ ③ □ ③, Xu and others speakers, the public has lost; few tours who embarrassed him; the number of those penalties, difficulties also; the first storm and then
aversion to the public who do not fine matter to it; to thank the Committee who want to rest too. Bing anger greeted a long time and the sub, not much difference
, the police will move.
soldiers, numbers of non-expensive, no advantage, enough to lie at the root Liaodi the person from it. However, easily understood without taking into account the enemy husband who will capture
to others. The penalty of death is not pro, then refused to accept, difficult to use against you. Death penalty is not pro-attached and is not available. Therefore, the United
to the text, together by force, is that will take. Order Suxing to teach its people, the public service; orders not to teach the people factor, the
against the people. That element entrants, and the public Xiangde also.

terrain Posts

Sun Zi said:
terrain pass by, to hang those who have supported, there are narrow those who have insurance, who have much. I can go, he can
years, said Tong. Pass shape, high in the first Yang, Lee grain Road to War is profit. Can go, it is difficult to return, said hanging. Linked to form
who the enemy is unprepared, out of the victory, the enemy if prepared, out victorious, it is difficult to return, negative. I'm out of the negative, he out
and negative, said support. Branch shape, although the enemy benefit me, and I have not come out, the lead away to make out and attack the enemy half-interest. Ai
shape, I should his residence, will profit of pending enemy. If the ranks of the enemy first, profit Erwu from, do not profit from it. Risks to shape,
of my first home, will be home to the enemy Goyang; if the first ranks of the enemy, away the lead, not from the can. Much to shape, are difficult to
potential challenge to fight a disadvantage. Where this six persons, to the road also will matter to any, must be aware also. All soldiers who have gone
have Chi those who have depression, who have collapsed, there is chaos, others to North. Where this six, non-World
the disaster, will be at fault also. Potential husband were to strike ten, said to go; Death strong weak officials, said Chi; Officials strong pawn is weak, said depression;
Dali angry and dissatisfied, Yudi hate war and since, will not know its capacity, said collapse; the weak lax, Religion and unknown, Lizu no
often, Summary of the horizon, said disorder; will not Liaodi to less Triangle to hit the weak strong, non-elected military front, said North. Where this
six who lost way too, will matter to any, must be aware also.
terrain husband who can help soldiers. Liaodi winning, namely Xianai distance, the road will be also. Who must know this and use the war
wins, I do not know this but with war comes before a fall. Battle Road win it, the Lord said, no war, war will be also; Road victorious war, the Lord said, will
war, no war can be too. It into not seeking the name does not avoid back offense, the only people is Paul, and conducive to the Lord, a national treasure.
such as infant death, it can work with to go to the stream; as death, such as son, it can be with them all die. Thick can not make,
not make love, chaos and can not rule Piruo pride, not use it. Death of
Zhiwu can hit, but I do not know the enemy can not attack, and beat half also; know the enemy can strike without Zhiwu death of
can not hit, and beat half also; know the enemy can strike , Zhiwu death of can hit, but I do not know the terrain of not war, wins half of
also. Refresher soldiers who move without the fans, move without the poor. Hence it is: Knowing your enemy, friend, your victory will not be threatened; Know the weather, know the terrain
, victory will be full.

to articles

nine grandchildren said:
military forces of the law, there are scattered places, with light to, a struggle to have to pay to, a thoroughfare to have powerhouse, a pan- to have
around to have death. Since the war the land lords who, as a casual manner; not deep into the land of people who, for the light to; I have to also benefit,
Peter, who also benefit, as the struggle to; I can go, he can come by, as surrenders; feudal land of three genera, Xianzhi derived
world public who, for the way thoroughfare; deep into the land of people, cities and more are back for the powerhouse; mountains, obstacles, Ju Ze, where hard
line of the Tao, the Pan-land; are run into those narrow, the migration from the homeless, he has few of the public who can hit my order around in; disease
war is to survive, fight disease is not dead, as death. Therefore in bulk to no war, no light to stop, competing for no attack, no absolute cross
way, thoroughfare to the Stock Exchange, powerhouse is swept, the pan to the line, around to the plan, death the war.
Gu Zhishan military forces who, before the enemy can not phase and, Zhonggua incompatible rely, are equal do not rescue, do not up and down relative to income
, and death rather than from the set of joint forces and not homogeneous. Moving together in the interest, are not in the interests full length. Dare to ask the public enemy, and the entire future, to be
of Ruo He said: wins their first love is listening to carry on. Soldiers love the main speed, take less person. By the unexpected way, they do not attack
ring also.
off the road where the depth is special. Owner not be able to, swept in wild Rao, armed enough to eat. Would like to raise Erwu labor, and product gas
force, personnel carriers trick for the unpredictable.
nothing to throw the dead and not the North. Yan shall not die, scholars do. Depression is very afraid of the soldiers, nothing to the solid
, depth is arrested, then forced to fight. Therefore in the military does not repair the ring, no derived, not about the parents, do not make the letter,
Ban Xiang to suspect, nothing of death.
I who it demonstrated financial, non-evil goods also; it demonstrated life, non-evil life also. Order issued the day, his soldiers seated tears s garments, Yan Yi
lying by tears make, nothing to throw, Zhu, Gui of courage. Gushan military forces who, for example Shuairan. Lvran who Changshan
of snakes. Its first to hit the tail, is the first to hit its tail, then the sum of all of them to hit. Dare to ask the soldiers if Shuairan can almost
? Can be said. Fu Wu Man and more of people's bad too, when the same boat and the economic and the case of wind, but also as its right hand is extended. Therefore in horses buried side
round, not enough to rely too; Qi Yong as one, the government way too; Rigid Chieh-te, to the management also. Gushan military forces who carry
subject the one hand, a last resort also.
general matter, to quiet quiet, is to cure, to fool the eyes and ears of his soldiers, so ignorant; easy to the event, reform of its plan,
makes no education; changes of the home, migrating their way, so that People may not consider. Handsome with it on, such as climbing the ladder away; handsome princes with whom deep
into place, and made the machine. If the drive sheep, drive and go, drive from, Mozhi by it. Together the three services of the public, to vote
of the risk, what we called the general things too.
nine to the change in flexion and extension of the power of human reason, must be aware also.
where the passengers of the Road, Shenzhen is designed, light is scattered. Cross-border and teachers are out of the country, the Jedi are; four Toru who Qu to have;
into the deep who powerhouse also; into the light who is also lightly; back were solid before the narrow, confining places also; nothing to those who of death also.
Therefore in bulk to happiness of a chi, so that is a light to Wu Jiang, Wu Jiang increasingly competing for subsequent delivery to Wu Jiang would like the keep,
solid happiness of the cross to its end, Qu to Wu Jiang would like the dependable, powerhouse happiness of following their food, their way into the pan to Wu Jiang, Wu Jiang
around to plug the palace to kill the happiness of the show is not live.
soldiers love it: around the defense, and forced the fighting, over from. Therefore in the plan
princes who do not know, can not be prepaid; I do not know the mountains, obstacles, Ju Ze of shape, can not march;
not rural guide, can not be geographical. Four or five persons, one I do not know, not King of the soldiers also. King of the soldier husband, cutting power,
then the public may gather; Weijia the enemy, their pay shall not be combined. Therefore in the world do not compete at the turn of the right thing in the world do not support the letter
our own private, Weijia on the enemy, then the city can pull out, the State may destroy.
facilities can not be the reward, no government suspended the order. Guilty of the three services of the public, subject the person. Guilty of the thing, do not tell the words; committed
of the victims, do not tell the benefit. Then vote to keep the death, the death trap and students. Husband caught the public harm, and then be able to win
defeat.
it is a matter of soldiers, the enemy in detail the meaning of Shun, and the enemy has always been, will kill thousands of miles, is that clever hosts. Therefore in the day
political move, Yi Guan break off, no pass its so, Li in the ############## above the temple, to punish the case. Opening and closing the enemy, must urgently into the first
their love of micro-contrast, practice with the enemy ink to do battle. Therefore in the beginning such as the virgin, the enemy opening; post such as rabbits,
less resist the enemy.

Fire Attack articles

Sun Tzu said:
where Fire will have five: one person said the fire, second is the fire product, third is the fire y, Si Yue fire, library, Wu Yue fire team.
there must be a result of the fire line, as will be a factor. Sometimes angry, fire a day. When those days are dry. Days, months in
Kei, wall, wing, Zhen also. The above activities were four places, the wind from the day also. Where a Fire Attack, will change because of five should the fire: the fire occurred in the
is long overdue is to the outside; fire sent its soldiers were quiet until the Erwu attack, extremely fire can be so from the, from then on not
. Fire can be made on the outside, no question in the order is issued when the fire made the upper hand, no capture of the wind, the wind a long day and night
wind only. Five military must know where the fire of change, in order to keep the number.
Junior attacker so the fire out with water junior attacker strong. Water can never, can not be won.
husband took it over but not idle power by its fierce, Ming Yue \Hence it is: the next main consideration, good will be inert, the non
fixed interest, have to do, non-crisis without a fight. Xingshi not anger the Lord, will not be indignant and necessary condition for battles.
Together in the interest and action, inconsistent with the previous benefit. Anger can be re-hi, resentment can be complex, said complex can not be kept subjugated, not the dead back to life
. Therefore, the next main caution, warning of good will. The road to Yasukuni army also.

alienate Posts:

Sun Tzu said:
who Xingshi million, and set off thousands of miles, the people of the fee, the public sector of Feng, the daughter of day rates, internal and external disturbances, lazy road
Road, not things are operating, seven hundred thousand. Spend several years in order to compete win, and Love Peerage hundred gold, I do not know who the enemy situation
, heartless matter to it, Africa and China is going to have, not the Lord of the rank and file also, can not win the primary. So it could maintain the action and
Yin wins, successful out of all those prophets. Prophets, not desirable in the spirits, not like at all, not experience in the degree of
, will take on the people who know the enemy situation also.
so with five rooms: a result, the rooms are inside, there are anti-room, there are dead, the animate rooms. All five, the Mozhi its
Road, is that the discipline of God, The ruler of the treasure. Country who,belstaff sale, because of the use of local people; in between those, because Husband and used
; discord among those between the use of their enemy; death among persons, things to deceive the outside, so I have heard knowledge of the transfer between the enemy also; Health
among those reported to have anti-. Therefore, the three services of the things in between pro-Mo, Mo thickness in the reward, the matter density in Mo, the non-sage can not be used
, the non-benevolence is not so, the non-subtle not have room in reality. Micro-micro-zai zai! There is also nothing to do. Do not send
between the first and the listener, who, among those with the report and death. Where is the voice of the military strike, the city of the Yu Gong, one of the Yusha, we must first know these
defender, left, Yezhe, door persons, Scheeren name, so I will claim to know the room. Between the enemy to those who asked me, so
benefit of, and the homes of lead, so use it against inter-Ke Deer; reason is wise or home, the inner room Ke Deer so also; because
is with knowledge Therefore, to lie among dead things, can tell the enemy; reason is with knowledge, so students can schedule rooms. Five things,belstaff online,
the Lord will know it, know the will is the anti-room, it is not no room Anti-thick also.
Xi Yin Hing also, loved Iraq in the summer; weeks Hing also, in the Yin Lu teeth. It could maintain Yin will be able to Chile was among more than those
, will become the great service. The soldiers want to, relies on the three services of the moving also.

[oi1yum4ei6ku]

Clerk Finance can be used. - Qzone log


| Back to logs list

Reprinted from 819898 at 5:10 p.m. on August 10, 2010 Read (loading. ..) Comments (0) Category: Personal Diary
Word trick:
one, enter the three \Third, enter the three \CHOOSE (WEEKDAY (I3, 2), \; show of the week
Excel common functions Daquan

1, ABS function
function name: ABS
main functions: the absolute value of the corresponding figures obtained.
using the format: ABS (number)
Parameter Description: number to be requested on behalf of the absolute value or reference cell.
Example: If cell B2 enter the formula: = ABS (A2), in both cell A2 enter a positive number (eg 100) or negative (eg -100), B2 in both show positive (eg 100).
to remind: If the number parameter is not numeric, but some characters (such as A, etc.), then the error value is returned B2 \
2, AND function
function name: AND
main functions: to return the logical value: if all parameters are the logical \logical \
using the format: AND (logical1, logical2, ...)
Parameter Description: Logical1, Logical2, Logical3 ... ...: the conditions to be tested, said the value or expression, up to the 30.
Example: enter the formula in cell C5: = AND (A5> = 60, B5> = 60), confirmed. If the C5 return TRUE, shows the value in A5 and B5 were greater than or equal to 60, if return FALSE, that the values in the A5 and B5 at least one of less than 60.
to remind: If you specify a logical condition parameter contains non-logical values, then the function returns the error value \
3, AVERAGE function
function name: AVERAGE
main functions: Find the arithmetic mean of all parameters.
using the format: AVERAGE (number1, number2, ... ...)
Parameter Description: number1, number2, ... ...: to request the reference value or the average cell (area), the parameter does not exceed 30.
Application examples: in B8 cells enter the formula: = AVERAGE (B7: D7, F7: H7, 7,red wing shoes,8), is confirmed, you can find the area B7 to D7, F7 to H7 area values and average of 7,8.
to remind: If the reference area contains \
4,red wing shoes sale, COLUMN function
function name: COLUMN
main functions: display the column label reference value of the cell.
using the format: COLUMN (reference)
Parameter Description: reference to reference cell.
Application examples: In the cell C11 enter the formula: = COLUMN (B11), confirmation is displayed as 2 (the B column).
to remind: If cell B11 enter the formula: = COLUMN (), also shows that 2; with the corresponding label value and a return line of the function - ROW (reference).
5, CONCATENATE function
function name: CONCATENATE
main functions: the number of characters in text or data in a cell together, displayed in a cell.
using the format: CONCATENATE (Text1, Text ... ...)
Parameter Description: Text1, Text2 ... ... the need to connect the characters of text or reference cell.
Application examples: In the cell C14 enter the formula: = CONCATENATE (A14 ,\characters and. com connection as a whole, appears in cell C14.
to remind: If the argument is not a reference cell, and the text format, please give the English state parameters with double quotes, if you change the formula: = A14 &\. com \
6, COUNTIF function
function name: COUNTIF
main features: a range of cells that meet specified statistical criteria the number of cells.
using the format: COUNTIF (Range, Criteria)
Parameter Description: Range on behalf of a range of cells to statistics; Criteria that specify the conditional expression.
Application examples: In the cell C17 enter the formula: = COUNTIF (B1: B13, \the number of cells.
remind: to allow a range of cells referenced in the blank cells appear.
7, DATE function
function name: DATE
main functions: the values given in the specified date.
using the format: DATE (year, month, day)
Parameter Description: year value for the specified year (less than 9999); month for a specified number of months (can be greater than 12); day for a specified number of days .
Application examples: In the cell C20 enter the formula: = DATE (2003,13,35), confirmation, show 2004-2-4.
reminded: As the above formula, the month is 13, more than a month, postponed to January 2004; 35 days, compared with January 2004 the actual number of days the addition of 4 days, it is also extended to 2004 on February 4.
8,red wing shoes outlet, the function name: DATEDIF
main functions: calculate the difference between returns two date parameters.
using the format: = DATEDIF (date1, date2, \a date, date2 on behalf of a date later; y (m, d) asked to return to the annual difference between the two dates (month, day) number.
Application examples: In the cell C23 enter the formula: = DATEDIF (A23, TODAY (), \, and returns the number of years difference.
reminded: This is a hidden function in Excel, is found in the Function Wizard, you can use direct input for the calculation of age, length of service and so very effective.
9, DAY function
function name: DAY
main functions: Find the reference to a specified date or the date the cell number of days.
using the format: DAY (serial_number)
Parameter Description: serial_number on behalf of the specified date or reference cell.
Example: enter the formula: = DAY (\
to remind: If the given date, include double quotation marks in English.
10, DCOUNT function
function name: DCOUNT
main functions: to return a database or list of columns to meet the specified conditions and the number of cells that contain numbers.
using the format: DCOUNT (database, field, criteria)
Parameter Description: Database statistics said the need for a range of cells; Field said that the data used in the function list (must be marks on the first line item); Criteria include Conditions range of cells.
Application examples: Figure 1 shows, in cell F4, enter the formula: = DCOUNT (A1: D11, \or equal to 70, while the value is less than 80 the number of cells (equivalent to the number of fractional section).

to remind: If you modify the above formula: = DCOUNT (A1: D11,, F1: G2), can also achieve the same purpose.
11, FREQUENCY function
function name: FREQUENCY
main functions: to return to a vertical array of data in an area frequency distribution.
using the format: FREQUENCY (data_array, bins_array)
Parameter Description: Data_array that used to calculate the frequency of a set of data or range of cells; Bins_array that separated the front of an array of values.
Application examples: as shown in Figure 2, while selected range of cells B32 to B36, enter the formula: = FREQUENCY (B2: B31, D2: D36), enter the complete press \key to confirm, you can find the B2 to the B31 area, according to D2 to D36 region separated values of the frequency of the number of segments (equivalent to the number of statistical segments of the score).

reminded: The input is an array formula, you're finished, you need to by pressing \({}), the braces can not be directly input.
12, IF function
function name: IF
main functions: According to the logic of the conditions specified in the true and false results, return the corresponding content.
using the format: = IF (Logical, Value_if_true, Value_if_false)
Parameter Description: Logical representative of logic expressions; Value_if_true that determine the conditions when the logical \TRUE \
Application examples: In the cell C29 enter the formula: = IF (C26> = 18, \the C29 cell displays \
remind: this article, similar to the \the corresponding cell, please refer to the specific instance of the file attached.
13, INDEX function
function name: INDEX
main functions: to return a list or array element value, this element by the row number and column number of the index values determined.
using the format: INDEX (array, row_num, column_num)
Parameter Description: Array on behalf of a range of cells or an array constant; Row_num that the specified line number (if omitted row_num, there must be column_num); Column_num that the specified column number (if omitted column_num, you must have row_num).
Application Example: Figure 3 shows, the F8 cell enter the formula: = INDEX (A1: D11, 4,3), confirmed the show range of cells A1 to D11, the first 4 rows and the intersection of three cells (ie, C4) in the content.

remind: line number argument here (row_num) and column number parameter (column_num) is relative to the terms of reference of the range of cells, not Excel worksheet rows or columns in the sequence number.
14, INT function
function name: INT
main functions: the value rounded down to the nearest integer.
using the format: INT (number)
Parameter Description: number expressed the need for rounding numeric values or include a reference cell.
Example: enter the formula: = INT (18.89), confirmation shows 18.
remind: when in the rounded, without rounding; If you enter the formula = INT (-18.89), the result is returned to -19.

15, ISERROR function
function name: ISERROR
main functions: to test the functional return value for errors. If wrong, the function returns TRUE, otherwise returns FALSE.
using the format: ISERROR (value)
Parameter Description: Value that need to test the value or expression.
Example: enter the formula: = ISERROR (A35/B35), confirmation, if the B35 cell is empty or \
reminded: This function is usually associated with supporting the use of IF functions, if you modify the formula: = IF (ISERROR (A35/B35 ),\the cell appears empty, otherwise display A35/B35
results.
16, LEFT function
function name: LEFT
main functions: a text string from the first character, the interception of a specified number of characters.
using the format: LEFT (text, num_chars)
Parameter Description: text representative of the character string to be cut; num_chars interception of a given number of representatives.
Application example: assume that the cell holds the A38 \characters.
reminded: This function name in English means \
17, LEN function
function name: LEN
main functions: the number of characters in text string Statistics.
using the format: LEN (text)
Parameter Description: text, said text string to statistics.
Application example: assume that the cell holds the A41 \
reminded: LEN to statistics, whether in full-width characters, or half-width characters, each character are counted as \\
18, MATCH function
function name: MATCH
main functions: to return in the specified manner that matches the specified value of the corresponding elements in the array position.
using the format: MATCH (lookup_value, lookup_array, match_type)
Parameter Description: Lookup_value representatives need to look at the data sheet value;
Lookup_array that may contain the values you want to find a continuous range of cells;
Match_type find the way that the value of (-1,0 or 1).
match_type to -1 if, find the smallest greater than or equal to lookup_value value, Lookup_array must be in descending order;
If match_type to 1, less than or equal to lookup_value find the maximum value, Lookup_array must be sorted in ascending order ;
If match_type 0, find the first value is equal to lookup_value, Lookup_array can be arranged in any order; If omitted match_type, the default is 1.
Application examples: Figure 4 shows, in cell F2 enter the formula: = MATCH (E2, B1: B11, 0), confirmed the results returned to find \

reminded: Lookup_array can only be one column or row.
19, MAX function
function name: MAX
main functions: Find the maximum value in a set of numbers.
using the format: MAX (number1, number2 ... ...)
Parameter Description: number1, number2 ... ... representatives to request the maximum value or a reference cell (area), the parameter does not exceed 30.
Example: enter the formula: = MAX (E44: J44, 7,8,9,10), confirmed to display the E44 to the J44 cells and in the region and the maximum value 7,8,9,10 .
to remind: If the parameters are text or logical values, is ignored.
20, MID function
function name: MID
main functions: a text string from the specified position, and the interception of a specified number of characters.
using the format: MID (text, start_num, num_chars)
Parameter Description: text represents a text string; start_num that specifies the starting position; num_chars that number to be intercepted.
Application example: assume that the cell holds the A47 \\
remind: the formula of the parameters, use the English state of the comma \
21, MIN function
function name: MIN
main functions: Find the minimum value in a set of numbers.
using the format: MIN (number1, number2 ... ...)
Parameter Description: number1, number2 ... ... representatives to request the minimum value or a reference cell (area), the parameter does not exceed 30.
Example: enter the formula: = MIN (E44: J44, 7,8,9,10), confirmed to display the E44 to the J44 cells and in the region and the minimum values 7,8,9,10 .
to remind: If the parameters are text or logical values, is ignored.
22, MOD function
function name: MOD
main functions: Find the remainder of dividing two numbers.
using the format: MOD (number, divisor)
Parameter Description: number representative of the dividend; divisor on behalf of the divisor.
Example: enter the formula: = MOD (13,4), confirmed the results show that \
to remind: If the divisor parameter is zero, then the error value \.
23, MONTH function
function name: MONTH
main functions: Find the reference to a specified date or the date cell of the month.
using the format: MONTH (serial_number)
Parameter Description: serial_number on behalf of the specified date, or reference cell.
Example: enter the formula: = MONTH (\
to remind: If the given date, include double quotation marks in English; if you modify the formula: = YEAR (\
24, NOW function
function name: NOW
main functions: given the current system date and time.
using the format: NOW ()
Parameter Description: This function takes no arguments.
Example: enter the formula: = NOW (), immediately after confirmation showing the current system date and time. If the system date and time changed, just click the F9 function key, you can let it change.
reminded: display the date and time format, you can re-set the cell formatting.
25, OR function
function name: OR
main functions: to return a logical value, only if all parameter values are logical \Otherwise, return a logical \
using the format: OR (logical1, logical2, ...)
Parameter Description: Logical1, Logical2, Logical3 ... ...: the conditions to be tested, said the value or expression, up to the 30.
Application examples: In the cell C62 enter the formula: = OR (A62> = 60, B62> = 60), confirmed. If C62 is returned TRUE, A62 and B62 in that at least one value greater than or equal to 60, if the return FALSE, that the values in A62 and B62 are less than 60.
to remind: If you specify a logical condition parameter contains non-logical values, then the function returns the error value \
26, RANK function
function name: RANK
main functions: to return a numeric value in a column in the ranking relative to other values.
using the format: RANK (Number, ref, order)
Parameter Description: Number values to sort the representative; ref numerical order in which the representatives of a range of cells; order on behalf of sort parameters (if it is \ignored, according ranked in descending order, the larger the number, the smaller the value of ranking results; if non-\
Example: If cell C2 enter the formula: = RANK (B2, $ B $ 2: $ B $ 31,0), D 1 can be derived after confirmation of language students in his class ranking in the results results.
remind: In the above formula, we let the Number parameter to a relative reference to the form, and let the ref parameter to the absolute reference in the form (adding a \mouse over the lower right corner of the cell, into thin cross-linear (usually called the \complete ranking scores of other students language statistics.
27, RIGHT function
function name: RIGHT
main functions: a text string from the last character in the beginning, the interception of a specified number of characters.
using the format: RIGHT (text, num_chars)
Parameter Description: text representative of the character string to be cut; num_chars interception of a given number of representatives.
Application example: assume that the cell holds the A65 \characters.
reminded: Num_chars parameter must be greater than or equal to 0, if omitted, the default it is 1; num_chars parameter is greater than if the length of the text, the function returns the entire text.
28, SUBTOTAL function
function name: SUBTOTAL
main functions: to return a list or database subtotals.
using the format: SUBTOTAL (function_num, ref1, ref2, ...)
Parameter Description: Function_num 1 to 11 (includes hidden values) or 101-111 (ignores hidden values) between the figures for What is the function specified in the list with subtotals calculated (Figure 6); ref1, ref2, ... ... on behalf of regional or subtotals to be a reference to not more than 29.
Application examples: as shown in Figure 7, the cells in the B64 and C64, respectively, enter the formula: = SUBTOTAL (3, C2: C63) and = SUBTOTAL103, C2: C63), and will hide the line 61, after confirmation The former appear as 62 (including the hidden rows), which appears as 61, not including the hidden rows.


to remind: If you take automated screening, no matter what type function_num parameters are chosen, SUBTOTAL function ignores any screening results are not included in the line; SUBTOTAL function is applied to the data columns or vertical area, does not apply to row or level area.
29, the function name: SUM
main functions: the calculation of all parameters and values.
using the format: SUM (Number1, Number2 ... ...)
Parameter Description: Number1, Number2 ... ... need to calculate the representative value may be a specific value, a reference cell (area), logical values and so on.
Application examples: as shown in Figure 7, in the cell D64 enter the formula: = SUM (D2: D63), confirmed the language of the score can be calculated.
to remind: If the argument is an array or reference, only one of the numbers will be calculated. Blank the array or reference cells, logical values, text or error values are ignored; if you modify the formula: = SUM (LARGE (D2: D63, {1,2,3,4,5})), you can find the top 5 results and.
30, SUMIF function
function name: SUMIF
main functions: to meet specified conditions for calculating the value and the range of cells.
using the format: SUMIF (Range, Criteria, Sum_Range)
Parameter Description: Range to determine the range of cells representative of conditions; Criteria for the specified conditional expression; Sum_Range need to calculate the value representative of where the range of cells.
Application examples: as shown in Figure 7, in the cell D64 enter the formula: = SUMIF (C2: C63, \.
to remind: If you modify the above formula: = SUMIF (C2: C63, \Because it is text-based, needs to be placed under the English double quotes (\
31, TEXT function
function name: TEXT
main functions: the value specified format according to the corresponding number into text form.
using the format: TEXT (value, format_text)
Parameter Description: value to convert the value on behalf of or reference to the cell; format_text for the specified text in the form of digital format.
Example: If the B68 cell preservation values 1280.45, we enter the formula in cells C68: = TEXT (B68, \
reminded: format_text parameters under the \
32, TODAY function
function name: TODAY
main functions: given the system date.
using the format: TODAY ()
Parameter Description: This function takes no arguments.
Example: enter the formula: = TODAY (), confirm that immediately after the system date and time display. If the system date and time changed, just click the F9 function key, you can let it change.
remind: the date format displayed, you can re-set the cell format (see annex).
33, VALUE function
function name: VALUE
main functions: the value of a text on behalf of the string is converted to numeric type.
using the format: VALUE (text)
Parameter Description: text-based representatives need to convert the text string value.
Example: If the B74 cell function is the interception by LEFT and other text-based strings, we enter the formula in cells C74: = VALUE (B74), confirmed, can be converted to numeric.
to remind: If the text type value is not a result of these conversions, the use of the function to deal with these values, often returns error.
34, VLOOKUP function
function name: VLOOKUP
main functions: the first column in the data table to find the specified value, and thus returns the current row in the table at the specified column value.
using the format: VLOOKUP (lookup_value, table_array, col_index_num, range_lookup)
Parameter Description: Lookup_value representatives need to find value; Table_array representatives need to find data in which the range of cells; Col_index_num in the region to be returned table_array match the value of the column number (when Col_index_num is 2, the return table_array values in column 2, 3, the return value of column 3 ... ...); Range_lookup is a logical value, if it is TRUE or omitted, the return approximate match, that is, if can not find an exact match, it returns the maximum value of less than lookup_value; If FALSE, it returns an exact match, if not, it returns the error value # N / A.
Application example: see Figure 7, we enter the formula in cell D65: = VLOOKUP (B65, B2: D63, 3, FALSE), confirmed, as long as the cell B65, enter a student's name (such as D 48),red wing mens boots, D65 cells showed immediate results of the student's language.
reminded: Lookup_value must Table_array see the first column of the region; if ignored Range_lookup parameters, Table_array the first column must be sorted; the Wizard in this function, the Range_lookup parameter usage is wrong.
35, WEEKDAY function
function name: WEEKDAY
main functions: the date given corresponds to the specified number of weeks.
using the format: WEEKDAY (serial_number, return_type)
Parameter Description: serial_number on behalf of the specified date or dates of that contains the cell references; return_type representation on behalf of weeks [when the Sunday (Sunday) to 1, Saturday (Saturday ) is 7, this parameter is 1; when Monday (Monday) 1, Sunday (Sunday) to 7, this parameter is 2 (this is in line with the Chinese habit of); when Monday (Monday) to 0 , Sunday (Sunday) to 6, this parameter is 3].
Example: enter the formula: = WEEKDAY (TODAY (), 2), confirm the system date is given after the number of weeks.
to remind: If the specified date, please put the English under the double quotes, such as = WEEKDAY (\
one. Select a color effect to the cell form, format - conditional formatting, conditions, select the \


1. interlacing color effect (odd row colors):
= MOD (ROW (), 2) = 1
2. interlaced color effect (even row colors):
= MOD (ROW (), 2) = 0
3. If you want to set the format for each application of a shading line 3,red wing motorcycle boots, you can use the formula:
= MOD (ROW (), 3) = 1
4. If you want to set different odd and even column shading, as long as the formula of the ROW () to COLUMN () can, such as:
= MOD (COLUMN (), 2)
5. If you want to set chess checkerboard shading (white + custom color):
= MOD (ROW () + COLUMN (), 2)
Description: The conditional formatting formula used to determine the line number and column number and the remainder is divided by 2 to 0. If 0, indicating the number of rows and columns of the same parity, then fill the cell to the specified color, or not filled. In the conditional formatting, the formula results to return a number, non-0 numbers is the TRUE, 0, and the error value is FALSE. Therefore, the above formula can be written as:
= MOD (ROW () + COLUMN (), 2) 0
6. If you want to set the chess checkerboard shading (custom colors + custom color):
add style 2:
= MOD (ROW () + COLUMN (), 2) = 0
II. Color filter can
excel2007 cell color, font color or icon to be sorted.
If excel2003, need to add auxiliary column, the name of the method defined by the color of the corresponding number, then the secondary sort column:
color cell in column A, select B1, Insert -> Name - > definition, input a, input the following formula = get.cell (24, $ a1),
this method get the serial number of the font color. B1 enter = a copy the formula down to the appropriate line.
the full table can be sorted by column B. If want to get the background color of the serial number will be changed to 63 to 24.
== \into the name to use
2.Get.Cell (Num, Cell) is the function of the form, Get.Cell can get a cell in a variety of information, such as frame format, etc., Num is specified to obtain the kind of information, 24 out this function is to let the color information unit, taken out after a 1-56 number to represent color number
3. B1 column if you enter your name and fill out the definition, then A1 B1 in the figure is the color code, B2 is A2 in the figure will be the color code, and so
4. Now you press the B column sort, in fact, according to color sort column A the.
attached Get.Cell the meaning of each parameter:
1 refer to the absolute address cell reference cells
2 No.
3 column reference column number cell similar
4 TYPE function
5 with reference to the text contents of the address
6 shows the light formula
7 with reference to the address format of the address, text display text display
8 format
9 with reference to the address to return extra storage box left style, figures show
10 extra storage box on the right to return the style, the figures show
11 store extra return on the style side box, digital display
12 frame side return the extra storage under the style, number of Show
13 returns the internal drawings, figures show
14 locked if the cell is set to return True
15 is hidden if the formula returns True
16
returns the width of the cell 17 points as the unit returned to the cell height
18 point font name
19 to return the font size for the unit cell all
20 or if a character is bold return True
21 If all or a cell in italics the first character returns True
22 If all or a cell first character is a single bottom line returns True
23 if the cell or the first characters of all the middle of a horizontal line font Returns True
24 returns the first character color cell number, 1 to 56. If set to automatic, returns 0
25 MS Excel does not support the outline format
26 MS Excel format does not support the shadow figures
27 insert page breaks manually set the outline of the column
28 Outline of the field-level
29
30 if the level of the outline summary of the range compared to True
31 if the range is the outline of the summary column was True
32 shows the workbook and worksheet name of the
33 If the cell formatting for multiple lines of text compared to True
34 extra storage box on the left to return the color, figures show. If set to automatic, returns 0
35 extra storage box on the right to return the color,red wing store, figures show. If set to automatic, returns 0
36 extra storage box at the top to return color, figures show. If set to automatic, returns 0
37 return save extra box below the color, figures show. If set to automatic, returns 0
38 cells future returns shadow colors, figures show. If set to automatic, returns 0
39 returns the cell back shadow color, figures show. If set to automatic, returns 0
40 text display cell style
41 returns the address of the original equation reference
42 points as the unit returned to the use of the left window on the left to the level of cell Distance
43 in points in the top of the window to return to using the cell above the vertical distance
44 in points in the window on the left to return to the use of a cell to the right of the horizontal distance
45 points unit returns to the top of the window used in the cell below the vertical distance
46 are inserted comments if the cell returns True
47 if the cell has to insert a sound prompt return True
48 are inserted into the formula if cell Returns True
49 if the cell is an array formula returns the range of returns True
50 cell vertical alignment, the figures show
51 perpendicular to the direction of the cell returned, figures show
52 pass back to the cell prefix character
53 text display shows the contents of the cell returned
54 returns the name of the PivotTable cell
55 returns the cell in the PivotTable pivot position
56
57 If all or a cell first character is superscript text return True
58 shows return of all or a cell font style
59 characters return the cell bottom line style, the figures show
60 If all or a cell for the first character subscript returns True
61 pivot
62 shows the workbook and worksheet name
63 returns the fill color of a cell mass
64 Back to the drawing foreground color
65 pivot
66 shows the workbook name

[1o7h0a8n1y]

Clerk Finance can be used. - Qzone log


| Back to logs list

Reprinted from 819898 at 5:10 p.m. on August 10, 2010 Read (loading. ..) Comments (0) Category: Personal Diary
Word trick:
one, enter the three \Third, enter the three \CHOOSE (WEEKDAY (I3, 2), \; show of the week
Excel common functions Daquan

1, ABS function
function name: ABS
main functions: the absolute value of the corresponding figures obtained.
using the format: ABS (number)
Parameter Description: number to be requested on behalf of the absolute value or reference cell.
Example: If cell B2 enter the formula: = ABS (A2), in both cell A2 enter a positive number (eg 100) or negative (eg -100), B2 in both show positive (eg 100).
to remind: If the number parameter is not numeric, but some characters (such as A, etc.), then the error value is returned B2 \
2, AND function
function name: AND
main functions: to return the logical value: if all parameters are the logical \logical \
using the format: AND (logical1, logical2, ...)
Parameter Description: Logical1, Logical2, Logical3 ... ...: the conditions to be tested, said the value or expression, up to the 30.
Example: enter the formula in cell C5: = AND (A5> = 60, B5> = 60), confirmed. If the C5 return TRUE, shows the value in A5 and B5 were greater than or equal to 60, if return FALSE, that the values in the A5 and B5 at least one of less than 60.
to remind: If you specify a logical condition parameter contains non-logical values, then the function returns the error value \
3, AVERAGE function
function name: AVERAGE
main functions: Find the arithmetic mean of all parameters.
using the format: AVERAGE (number1, number2, ... ...)
Parameter Description: number1, number2, ... ...: to request the reference value or the average cell (area), the parameter does not exceed 30.
Application examples: in B8 cells enter the formula: = AVERAGE (B7: D7, F7: H7, 7,8), is confirmed, you can find the area B7 to D7, F7 to H7 area values and average of 7,8.
to remind: If the reference area contains \
4, COLUMN function
function name: COLUMN
main functions: display the column label reference value of the cell.
using the format: COLUMN (reference)
Parameter Description: reference to reference cell.
Application examples: In the cell C11 enter the formula: = COLUMN (B11), confirmation is displayed as 2 (the B column).
to remind: If cell B11 enter the formula: = COLUMN (), also shows that 2; with the corresponding label value and a return line of the function - ROW (reference).
5, CONCATENATE function
function name: CONCATENATE
main functions: the number of characters in text or data in a cell together, displayed in a cell.
using the format: CONCATENATE (Text1, Text ... ...)
Parameter Description: Text1, Text2 ... ... the need to connect the characters of text or reference cell.
Application examples: In the cell C14 enter the formula: = CONCATENATE (A14 ,\characters and. com connection as a whole, appears in cell C14.
to remind: If the argument is not a reference cell, and the text format, please give the English state parameters with double quotes, if you change the formula: = A14 &\. com \
6, COUNTIF function
function name: COUNTIF
main features: a range of cells that meet specified statistical criteria the number of cells.
using the format: COUNTIF (Range, Criteria)
Parameter Description: Range on behalf of a range of cells to statistics; Criteria that specify the conditional expression.
Application examples: In the cell C17 enter the formula: = COUNTIF (B1: B13, \the number of cells.
remind: to allow a range of cells referenced in the blank cells appear.
7, DATE function
function name: DATE
main functions: the values given in the specified date.
using the format: DATE (year, month, day)
Parameter Description: year value for the specified year (less than 9999); month for a specified number of months (can be greater than 12); day for a specified number of days .
Application examples: In the cell C20 enter the formula: = DATE (2003,13,35), confirmation, show 2004-2-4.
reminded: As the above formula, the month is 13, more than a month, postponed to January 2004; 35 days, compared with January 2004 the actual number of days the addition of 4 days, it is also extended to 2004 on February 4.
8, the function name: DATEDIF
main functions: calculate the difference between returns two date parameters.
using the format: = DATEDIF (date1, date2, \a date, date2 on behalf of a date later; y (m, d) asked to return to the annual difference between the two dates (month, day) number.
Application examples: In the cell C23 enter the formula: = DATEDIF (A23, TODAY (), \, and returns the number of years difference.
reminded: This is a hidden function in Excel,red wing work boots, is found in the Function Wizard, you can use direct input for the calculation of age, length of service and so very effective.
9, DAY function
function name: DAY
main functions: Find the reference to a specified date or the date the cell number of days.
using the format: DAY (serial_number)
Parameter Description: serial_number on behalf of the specified date or reference cell.
Example: enter the formula: = DAY (\
to remind: If the given date, include double quotation marks in English.
10, DCOUNT function
function name: DCOUNT
main functions: to return a database or list of columns to meet the specified conditions and the number of cells that contain numbers.
using the format: DCOUNT (database, field, criteria)
Parameter Description: Database statistics said the need for a range of cells; Field said that the data used in the function list (must be marks on the first line item); Criteria include Conditions range of cells.
Application examples: Figure 1 shows, in cell F4, enter the formula: = DCOUNT (A1: D11, \or equal to 70, while the value is less than 80 the number of cells (equivalent to the number of fractional section).

to remind: If you modify the above formula: = DCOUNT (A1: D11,, F1: G2), can also achieve the same purpose.
11, FREQUENCY function
function name: FREQUENCY
main functions: to return to a vertical array of data in an area frequency distribution.
using the format: FREQUENCY (data_array, bins_array)
Parameter Description: Data_array that used to calculate the frequency of a set of data or range of cells; Bins_array that separated the front of an array of values.
Application examples: as shown in Figure 2, while selected range of cells B32 to B36, enter the formula: = FREQUENCY (B2: B31, D2: D36), enter the complete press \key to confirm, you can find the B2 to the B31 area, according to D2 to D36 region separated values of the frequency of the number of segments (equivalent to the number of statistical segments of the score).

reminded: The input is an array formula, you're finished, you need to by pressing \({}), the braces can not be directly input.
12, IF function
function name: IF
main functions: According to the logic of the conditions specified in the true and false results, return the corresponding content.
using the format: = IF (Logical, Value_if_true, Value_if_false)
Parameter Description: Logical representative of logic expressions; Value_if_true that determine the conditions when the logical \TRUE \
Application examples: In the cell C29 enter the formula: = IF (C26> = 18, \the C29 cell displays \
remind: this article, similar to the \the corresponding cell, please refer to the specific instance of the file attached.
13, INDEX function
function name: INDEX
main functions: to return a list or array element value, this element by the row number and column number of the index values determined.
using the format: INDEX (array, row_num, column_num)
Parameter Description: Array on behalf of a range of cells or an array constant; Row_num that the specified line number (if omitted row_num, there must be column_num); Column_num that the specified column number (if omitted column_num, you must have row_num).
Application Example: Figure 3 shows, the F8 cell enter the formula: = INDEX (A1: D11, 4,3), confirmed the show range of cells A1 to D11, the first 4 rows and the intersection of three cells (ie, C4) in the content.

remind: line number argument here (row_num) and column number parameter (column_num) is relative to the terms of reference of the range of cells, not Excel worksheet rows or columns in the sequence number.
14, INT function
function name: INT
main functions: the value rounded down to the nearest integer.
using the format: INT (number)
Parameter Description: number expressed the need for rounding numeric values or include a reference cell.
Example: enter the formula: = INT (18.89), confirmation shows 18.
remind: when in the rounded, without rounding; If you enter the formula = INT (-18.89), the result is returned to -19.

15, ISERROR function
function name: ISERROR
main functions: to test the functional return value for errors. If wrong, the function returns TRUE, otherwise returns FALSE.
using the format: ISERROR (value)
Parameter Description: Value that need to test the value or expression.
Example: enter the formula: = ISERROR (A35/B35), confirmation, if the B35 cell is empty or \
reminded: This function is usually associated with supporting the use of IF functions, if you modify the formula: = IF (ISERROR (A35/B35 ),\the cell appears empty, otherwise display A35/B35
results.
16, LEFT function
function name: LEFT
main functions: a text string from the first character, the interception of a specified number of characters.
using the format: LEFT (text, num_chars)
Parameter Description: text representative of the character string to be cut; num_chars interception of a given number of representatives.
Application example: assume that the cell holds the A38 \characters.
reminded: This function name in English means \
17,red wing shoes online, LEN function
function name: LEN
main functions: the number of characters in text string Statistics.
using the format: LEN (text)
Parameter Description: text, said text string to statistics.
Application example: assume that the cell holds the A41 \
reminded: LEN to statistics, whether in full-width characters, or half-width characters, each character are counted as \\
18, MATCH function
function name: MATCH
main functions: to return in the specified manner that matches the specified value of the corresponding elements in the array position.
using the format: MATCH (lookup_value, lookup_array, match_type)
Parameter Description: Lookup_value representatives need to look at the data sheet value;
Lookup_array that may contain the values you want to find a continuous range of cells;
Match_type find the way that the value of (-1,0 or 1).
match_type to -1 if, find the smallest greater than or equal to lookup_value value, Lookup_array must be in descending order;
If match_type to 1, less than or equal to lookup_value find the maximum value, Lookup_array must be sorted in ascending order ;
If match_type 0, find the first value is equal to lookup_value, Lookup_array can be arranged in any order; If omitted match_type, the default is 1.
Application examples: Figure 4 shows, in cell F2 enter the formula: = MATCH (E2, B1: B11, 0), confirmed the results returned to find \

reminded: Lookup_array can only be one column or row.
19, MAX function
function name: MAX
main functions: Find the maximum value in a set of numbers.
using the format: MAX (number1, number2 ... ...)
Parameter Description: number1, number2 ... ... representatives to request the maximum value or a reference cell (area), the parameter does not exceed 30.
Example: enter the formula: = MAX (E44: J44, 7,8,9,10), confirmed to display the E44 to the J44 cells and in the region and the maximum value 7,8,9,10 .
to remind: If the parameters are text or logical values, is ignored.
20, MID function
function name: MID
main functions: a text string from the specified position, and the interception of a specified number of characters.
using the format: MID (text, start_num, num_chars)
Parameter Description: text represents a text string; start_num that specifies the starting position; num_chars that number to be intercepted.
Application example: assume that the cell holds the A47 \\
remind: the formula of the parameters, use the English state of the comma \
21, MIN function
function name: MIN
main functions: Find the minimum value in a set of numbers.
using the format: MIN (number1, number2 ... ...)
Parameter Description: number1, number2 ... ... representatives to request the minimum value or a reference cell (area), the parameter does not exceed 30.
Example: enter the formula: = MIN (E44: J44, 7,8,9,10), confirmed to display the E44 to the J44 cells and in the region and the minimum values 7,8,9,10 .
to remind: If the parameters are text or logical values, is ignored.
22,red wing motorcycle boots, MOD function
function name: MOD
main functions: Find the remainder of dividing two numbers.
using the format: MOD (number, divisor)
Parameter Description: number representative of the dividend; divisor on behalf of the divisor.
Example: enter the formula: = MOD (13,4), confirmed the results show that \
to remind: If the divisor parameter is zero, then the error value \.
23, MONTH function
function name: MONTH
main functions: Find the reference to a specified date or the date cell of the month.
using the format: MONTH (serial_number)
Parameter Description: serial_number on behalf of the specified date, or reference cell.
Example: enter the formula: = MONTH (\
to remind: If the given date, include double quotation marks in English; if you modify the formula: = YEAR (\
24, NOW function
function name: NOW
main functions: given the current system date and time.
using the format: NOW ()
Parameter Description: This function takes no arguments.
Example: enter the formula: = NOW (), immediately after confirmation showing the current system date and time. If the system date and time changed, just click the F9 function key, you can let it change.
reminded: display the date and time format, you can re-set the cell formatting.
25, OR function
function name: OR
main functions: to return a logical value, only if all parameter values are logical \Otherwise, return a logical \
using the format: OR (logical1, logical2, ...)
Parameter Description: Logical1, Logical2, Logical3 ... ...: the conditions to be tested, said the value or expression, up to the 30.
Application examples: In the cell C62 enter the formula: = OR (A62> = 60, B62> = 60), confirmed. If C62 is returned TRUE, A62 and B62 in that at least one value greater than or equal to 60, if the return FALSE, that the values in A62 and B62 are less than 60.
to remind: If you specify a logical condition parameter contains non-logical values, then the function returns the error value \
26, RANK function
function name: RANK
main functions: to return a numeric value in a column in the ranking relative to other values.
using the format: RANK (Number, ref, order)
Parameter Description: Number values to sort the representative; ref numerical order in which the representatives of a range of cells; order on behalf of sort parameters (if it is \ignored, according ranked in descending order, the larger the number, the smaller the value of ranking results; if non-\
Example: If cell C2 enter the formula: = RANK (B2, $ B $ 2: $ B $ 31,0), D 1 can be derived after confirmation of language students in his class ranking in the results results.
remind: In the above formula, we let the Number parameter to a relative reference to the form, and let the ref parameter to the absolute reference in the form (adding a \mouse over the lower right corner of the cell, into thin cross-linear (usually called the \complete ranking scores of other students language statistics.
27, RIGHT function
function name: RIGHT
main functions: a text string from the last character in the beginning, the interception of a specified number of characters.
using the format: RIGHT (text, num_chars)
Parameter Description: text representative of the character string to be cut; num_chars interception of a given number of representatives.
Application example: assume that the cell holds the A65 \characters.
reminded: Num_chars parameter must be greater than or equal to 0, if omitted, the default it is 1; num_chars parameter is greater than if the length of the text, the function returns the entire text.
28, SUBTOTAL function
function name: SUBTOTAL
main functions: to return a list or database subtotals.
using the format: SUBTOTAL (function_num, ref1, ref2, ...)
Parameter Description: Function_num 1 to 11 (includes hidden values) or 101-111 (ignores hidden values) between the figures for What is the function specified in the list with subtotals calculated (Figure 6); ref1, ref2,red wing boot store, ... ... on behalf of regional or subtotals to be a reference to not more than 29.
Application examples: as shown in Figure 7, the cells in the B64 and C64, respectively, enter the formula: = SUBTOTAL (3, C2: C63) and = SUBTOTAL103, C2: C63), and will hide the line 61, after confirmation The former appear as 62 (including the hidden rows), which appears as 61, not including the hidden rows.


to remind: If you take automated screening, no matter what type function_num parameters are chosen, SUBTOTAL function ignores any screening results are not included in the line; SUBTOTAL function is applied to the data columns or vertical area, does not apply to row or level area.
29, the function name: SUM
main functions: the calculation of all parameters and values.
using the format: SUM (Number1, Number2 ... ...)
Parameter Description: Number1, Number2 ... ... need to calculate the representative value may be a specific value, a reference cell (area), logical values and so on.
Application examples: as shown in Figure 7, in the cell D64 enter the formula: = SUM (D2: D63), confirmed the language of the score can be calculated.
to remind: If the argument is an array or reference,red wing shoes sale, only one of the numbers will be calculated. Blank the array or reference cells, logical values, text or error values are ignored; if you modify the formula: = SUM (LARGE (D2: D63,red wing shoes outlet, {1,2,3,4,5})), you can find the top 5 results and.
30, SUMIF function
function name: SUMIF
main functions: to meet specified conditions for calculating the value and the range of cells.
using the format: SUMIF (Range, Criteria, Sum_Range)
Parameter Description: Range to determine the range of cells representative of conditions; Criteria for the specified conditional expression; Sum_Range need to calculate the value representative of where the range of cells.
Application examples: as shown in Figure 7, in the cell D64 enter the formula: = SUMIF (C2: C63, \.
to remind: If you modify the above formula: = SUMIF (C2: C63, \Because it is text-based, needs to be placed under the English double quotes (\
31, TEXT function
function name: TEXT
main functions: the value specified format according to the corresponding number into text form.
using the format: TEXT (value, format_text)
Parameter Description: value to convert the value on behalf of or reference to the cell; format_text for the specified text in the form of digital format.
Example: If the B68 cell preservation values 1280.45, we enter the formula in cells C68: = TEXT (B68, \
reminded: format_text parameters under the \
32, TODAY function
function name: TODAY
main functions: given the system date.
using the format: TODAY ()
Parameter Description: This function takes no arguments.
Example: enter the formula: = TODAY (), confirm that immediately after the system date and time display. If the system date and time changed, just click the F9 function key, you can let it change.
remind: the date format displayed, you can re-set the cell format (see annex).
33, VALUE function
function name: VALUE
main functions: the value of a text on behalf of the string is converted to numeric type.
using the format: VALUE (text)
Parameter Description: text-based representatives need to convert the text string value.
Example: If the B74 cell function is the interception by LEFT and other text-based strings, we enter the formula in cells C74: = VALUE (B74), confirmed, can be converted to numeric.
to remind: If the text type value is not a result of these conversions, the use of the function to deal with these values, often returns error.
34, VLOOKUP function
function name: VLOOKUP
main functions: the first column in the data table to find the specified value, and thus returns the current row in the table at the specified column value.
using the format: VLOOKUP (lookup_value, table_array, col_index_num, range_lookup)
Parameter Description: Lookup_value representatives need to find value; Table_array representatives need to find data in which the range of cells; Col_index_num in the region to be returned table_array match the value of the column number (when Col_index_num is 2, the return table_array values in column 2, 3, the return value of column 3 ... ...); Range_lookup is a logical value, if it is TRUE or omitted, the return approximate match, that is, if can not find an exact match, it returns the maximum value of less than lookup_value; If FALSE, it returns an exact match, if not, it returns the error value # N / A.
Application example: see Figure 7, we enter the formula in cell D65: = VLOOKUP (B65, B2: D63, 3, FALSE), confirmed, as long as the cell B65, enter a student's name (such as D 48), D65 cells showed immediate results of the student's language.
reminded: Lookup_value must Table_array see the first column of the region; if ignored Range_lookup parameters, Table_array the first column must be sorted; the Wizard in this function, the Range_lookup parameter usage is wrong.
35, WEEKDAY function
function name: WEEKDAY
main functions: the date given corresponds to the specified number of weeks.
using the format: WEEKDAY (serial_number, return_type)
Parameter Description: serial_number on behalf of the specified date or dates of that contains the cell references; return_type representation on behalf of weeks [when the Sunday (Sunday) to 1, Saturday (Saturday ) is 7, this parameter is 1; when Monday (Monday) 1, Sunday (Sunday) to 7, this parameter is 2 (this is in line with the Chinese habit of); when Monday (Monday) to 0 , Sunday (Sunday) to 6, this parameter is 3].
Example: enter the formula: = WEEKDAY (TODAY (), 2), confirm the system date is given after the number of weeks.
to remind: If the specified date, please put the English under the double quotes, such as = WEEKDAY (\
one. Select a color effect to the cell form, format - conditional formatting, conditions, select the \


1. interlacing color effect (odd row colors):
= MOD (ROW (), 2) = 1
2. interlaced color effect (even row colors):
= MOD (ROW (), 2) = 0
3. If you want to set the format for each application of a shading line 3, you can use the formula:
= MOD (ROW (), 3) = 1
4. If you want to set different odd and even column shading, as long as the formula of the ROW () to COLUMN () can, such as:
= MOD (COLUMN (), 2)
5. If you want to set chess checkerboard shading (white + custom color):
= MOD (ROW () + COLUMN (), 2)
Description: The conditional formatting formula used to determine the line number and column number and the remainder is divided by 2 to 0. If 0, indicating the number of rows and columns of the same parity, then fill the cell to the specified color, or not filled. In the conditional formatting, the formula results to return a number, non-0 numbers is the TRUE, 0, and the error value is FALSE. Therefore, the above formula can be written as:
= MOD (ROW () + COLUMN (), 2) 0
6. If you want to set the chess checkerboard shading (custom colors + custom color):
add style 2:
= MOD (ROW () + COLUMN (), 2) = 0
II. Color filter can
excel2007 cell color, font color or icon to be sorted.
If excel2003, need to add auxiliary column, the name of the method defined by the color of the corresponding number, then the secondary sort column:
color cell in column A, select B1, Insert -> Name - > definition, input a, input the following formula = get.cell (24, $ a1),
this method get the serial number of the font color. B1 enter = a copy the formula down to the appropriate line.
the full table can be sorted by column B. If want to get the background color of the serial number will be changed to 63 to 24.
== \into the name to use
2.Get.Cell (Num, Cell) is the function of the form, Get.Cell can get a cell in a variety of information, such as frame format, etc., Num is specified to obtain the kind of information, 24 out this function is to let the color information unit, taken out after a 1-56 number to represent color number
3. B1 column if you enter your name and fill out the definition, then A1 B1 in the figure is the color code, B2 is A2 in the figure will be the color code, and so
4. Now you press the B column sort, in fact, according to color sort column A the.
attached Get.Cell the meaning of each parameter:
1 refer to the absolute address cell reference cells
2 No.
3 column reference column number cell similar
4 TYPE function
5 with reference to the text contents of the address
6 shows the light formula
7 with reference to the address format of the address, text display text display
8 format
9 with reference to the address to return extra storage box left style, figures show
10 extra storage box on the right to return the style, the figures show
11 store extra return on the style side box, digital display
12 frame side return the extra storage under the style, number of Show
13 returns the internal drawings, figures show
14 locked if the cell is set to return True
15 is hidden if the formula returns True
16
returns the width of the cell 17 points as the unit returned to the cell height
18 point font name
19 to return the font size for the unit cell all
20 or if a character is bold return True
21 If all or a cell in italics the first character returns True
22 If all or a cell first character is a single bottom line returns True
23 if the cell or the first characters of all the middle of a horizontal line font Returns True
24 returns the first character color cell number, 1 to 56. If set to automatic, returns 0
25 MS Excel does not support the outline format
26 MS Excel format does not support the shadow figures
27 insert page breaks manually set the outline of the column
28 Outline of the field-level
29
30 if the level of the outline summary of the range compared to True
31 if the range is the outline of the summary column was True
32 shows the workbook and worksheet name of the
33 If the cell formatting for multiple lines of text compared to True
34 extra storage box on the left to return the color, figures show. If set to automatic, returns 0
35 extra storage box on the right to return the color, figures show. If set to automatic, returns 0
36 extra storage box at the top to return color, figures show. If set to automatic, returns 0
37 return save extra box below the color, figures show. If set to automatic, returns 0
38 cells future returns shadow colors, figures show. If set to automatic, returns 0
39 returns the cell back shadow color, figures show. If set to automatic, returns 0
40 text display cell style
41 returns the address of the original equation reference
42 points as the unit returned to the use of the left window on the left to the level of cell Distance
43 in points in the top of the window to return to using the cell above the vertical distance
44 in points in the window on the left to return to the use of a cell to the right of the horizontal distance
45 points unit returns to the top of the window used in the cell below the vertical distance
46 are inserted comments if the cell returns True
47 if the cell has to insert a sound prompt return True
48 are inserted into the formula if cell Returns True
49 if the cell is an array formula returns the range of returns True
50 cell vertical alignment, the figures show
51 perpendicular to the direction of the cell returned, figures show
52 pass back to the cell prefix character
53 text display shows the contents of the cell returned
54 returns the name of the PivotTable cell
55 returns the cell in the PivotTable pivot position
56
57 If all or a cell first character is superscript text return True
58 shows return of all or a cell font style
59 characters return the cell bottom line style, the figures show
60 If all or a cell for the first character subscript returns True
61 pivot
62 shows the workbook and worksheet name
63 returns the fill color of a cell mass
64 Back to the drawing foreground color
65 pivot
66 shows the workbook name

[3xkfen5o3k5u]

Clerk Finance can be used. - Qzone log


| Back to logs list

Reprinted from 819898 at 5:10 p.m. on August 10, 2010 Read (loading. ..) Comments (0) Category: Personal Diary
Word trick:
one, enter the three \Third, enter the three \CHOOSE (WEEKDAY (I3, 2), \; show of the week
Excel common functions Daquan

1, ABS function
function name: ABS
main functions: the absolute value of the corresponding figures obtained.
using the format: ABS (number)
Parameter Description: number to be requested on behalf of the absolute value or reference cell.
Example: If cell B2 enter the formula: = ABS (A2), in both cell A2 enter a positive number (eg 100) or negative (eg -100), B2 in both show positive (eg 100).
to remind: If the number parameter is not numeric, but some characters (such as A, etc.), then the error value is returned B2 \
2, AND function
function name: AND
main functions: to return the logical value: if all parameters are the logical \logical \
using the format: AND (logical1, logical2, ...)
Parameter Description: Logical1, Logical2, Logical3 ... ...: the conditions to be tested, said the value or expression, up to the 30.
Example: enter the formula in cell C5: = AND (A5> = 60, B5> = 60), confirmed. If the C5 return TRUE, shows the value in A5 and B5 were greater than or equal to 60, if return FALSE, that the values in the A5 and B5 at least one of less than 60.
to remind: If you specify a logical condition parameter contains non-logical values, then the function returns the error value \
3, AVERAGE function
function name: AVERAGE
main functions: Find the arithmetic mean of all parameters.
using the format: AVERAGE (number1, number2, ... ...)
Parameter Description: number1, number2, ... ...: to request the reference value or the average cell (area), the parameter does not exceed 30.
Application examples: in B8 cells enter the formula: = AVERAGE (B7: D7, F7: H7,red wing work boots, 7,8), is confirmed, you can find the area B7 to D7, F7 to H7 area values and average of 7,8.
to remind: If the reference area contains \
4, COLUMN function
function name: COLUMN
main functions: display the column label reference value of the cell.
using the format: COLUMN (reference)
Parameter Description: reference to reference cell.
Application examples: In the cell C11 enter the formula: = COLUMN (B11), confirmation is displayed as 2 (the B column).
to remind: If cell B11 enter the formula: = COLUMN (), also shows that 2; with the corresponding label value and a return line of the function - ROW (reference).
5, CONCATENATE function
function name: CONCATENATE
main functions: the number of characters in text or data in a cell together, displayed in a cell.
using the format: CONCATENATE (Text1, Text ... ...)
Parameter Description: Text1, Text2 ... ... the need to connect the characters of text or reference cell.
Application examples: In the cell C14 enter the formula: = CONCATENATE (A14 ,\characters and. com connection as a whole, appears in cell C14.
to remind: If the argument is not a reference cell, and the text format, please give the English state parameters with double quotes, if you change the formula: = A14 &\. com \
6, COUNTIF function
function name: COUNTIF
main features: a range of cells that meet specified statistical criteria the number of cells.
using the format: COUNTIF (Range, Criteria)
Parameter Description: Range on behalf of a range of cells to statistics; Criteria that specify the conditional expression.
Application examples: In the cell C17 enter the formula: = COUNTIF (B1: B13, \the number of cells.
remind: to allow a range of cells referenced in the blank cells appear.
7, DATE function
function name: DATE
main functions: the values given in the specified date.
using the format: DATE (year, month, day)
Parameter Description: year value for the specified year (less than 9999); month for a specified number of months (can be greater than 12); day for a specified number of days .
Application examples: In the cell C20 enter the formula: = DATE (2003,13,35), confirmation, show 2004-2-4.
reminded: As the above formula, the month is 13, more than a month, postponed to January 2004; 35 days, compared with January 2004 the actual number of days the addition of 4 days, it is also extended to 2004 on February 4.
8, the function name: DATEDIF
main functions: calculate the difference between returns two date parameters.
using the format: = DATEDIF (date1, date2, \a date, date2 on behalf of a date later; y (m, d) asked to return to the annual difference between the two dates (month, day) number.
Application examples: In the cell C23 enter the formula: = DATEDIF (A23, TODAY (), \, and returns the number of years difference.
reminded: This is a hidden function in Excel, is found in the Function Wizard, you can use direct input for the calculation of age, length of service and so very effective.
9, DAY function
function name: DAY
main functions: Find the reference to a specified date or the date the cell number of days.
using the format: DAY (serial_number)
Parameter Description: serial_number on behalf of the specified date or reference cell.
Example: enter the formula: = DAY (\
to remind: If the given date, include double quotation marks in English.
10, DCOUNT function
function name: DCOUNT
main functions: to return a database or list of columns to meet the specified conditions and the number of cells that contain numbers.
using the format: DCOUNT (database, field, criteria)
Parameter Description: Database statistics said the need for a range of cells; Field said that the data used in the function list (must be marks on the first line item); Criteria include Conditions range of cells.
Application examples: Figure 1 shows, in cell F4, enter the formula: = DCOUNT (A1: D11, \or equal to 70, while the value is less than 80 the number of cells (equivalent to the number of fractional section).

to remind: If you modify the above formula: = DCOUNT (A1: D11,, F1: G2), can also achieve the same purpose.
11, FREQUENCY function
function name: FREQUENCY
main functions: to return to a vertical array of data in an area frequency distribution.
using the format: FREQUENCY (data_array, bins_array)
Parameter Description: Data_array that used to calculate the frequency of a set of data or range of cells; Bins_array that separated the front of an array of values.
Application examples: as shown in Figure 2, while selected range of cells B32 to B36, enter the formula: = FREQUENCY (B2: B31, D2: D36), enter the complete press \key to confirm, you can find the B2 to the B31 area, according to D2 to D36 region separated values of the frequency of the number of segments (equivalent to the number of statistical segments of the score).

reminded: The input is an array formula, you're finished, you need to by pressing \({}), the braces can not be directly input.
12, IF function
function name: IF
main functions: According to the logic of the conditions specified in the true and false results, return the corresponding content.
using the format: = IF (Logical, Value_if_true, Value_if_false)
Parameter Description: Logical representative of logic expressions; Value_if_true that determine the conditions when the logical \TRUE \
Application examples: In the cell C29 enter the formula: = IF (C26> = 18, \the C29 cell displays \
remind: this article, similar to the \the corresponding cell, please refer to the specific instance of the file attached.
13, INDEX function
function name: INDEX
main functions: to return a list or array element value, this element by the row number and column number of the index values determined.
using the format: INDEX (array, row_num, column_num)
Parameter Description: Array on behalf of a range of cells or an array constant; Row_num that the specified line number (if omitted row_num, there must be column_num); Column_num that the specified column number (if omitted column_num, you must have row_num).
Application Example: Figure 3 shows, the F8 cell enter the formula: = INDEX (A1: D11, 4,3), confirmed the show range of cells A1 to D11, the first 4 rows and the intersection of three cells (ie, C4) in the content.

remind: line number argument here (row_num) and column number parameter (column_num) is relative to the terms of reference of the range of cells, not Excel worksheet rows or columns in the sequence number.
14, INT function
function name: INT
main functions: the value rounded down to the nearest integer.
using the format: INT (number)
Parameter Description: number expressed the need for rounding numeric values or include a reference cell.
Example: enter the formula: = INT (18.89), confirmation shows 18.
remind: when in the rounded, without rounding; If you enter the formula = INT (-18.89), the result is returned to -19.

15, ISERROR function
function name: ISERROR
main functions: to test the functional return value for errors. If wrong, the function returns TRUE, otherwise returns FALSE.
using the format: ISERROR (value)
Parameter Description: Value that need to test the value or expression.
Example: enter the formula: = ISERROR (A35/B35), confirmation, if the B35 cell is empty or \
reminded: This function is usually associated with supporting the use of IF functions, if you modify the formula: = IF (ISERROR (A35/B35 ),\the cell appears empty, otherwise display A35/B35
results.
16, LEFT function
function name: LEFT
main functions: a text string from the first character, the interception of a specified number of characters.
using the format: LEFT (text, num_chars)
Parameter Description: text representative of the character string to be cut; num_chars interception of a given number of representatives.
Application example: assume that the cell holds the A38 \characters.
reminded: This function name in English means \
17, LEN function
function name: LEN
main functions: the number of characters in text string Statistics.
using the format: LEN (text)
Parameter Description: text, said text string to statistics.
Application example: assume that the cell holds the A41 \
reminded: LEN to statistics, whether in full-width characters, or half-width characters, each character are counted as \\
18, MATCH function
function name: MATCH
main functions: to return in the specified manner that matches the specified value of the corresponding elements in the array position.
using the format: MATCH (lookup_value, lookup_array, match_type)
Parameter Description: Lookup_value representatives need to look at the data sheet value;
Lookup_array that may contain the values you want to find a continuous range of cells;
Match_type find the way that the value of (-1,0 or 1).
match_type to -1 if, find the smallest greater than or equal to lookup_value value, Lookup_array must be in descending order;
If match_type to 1, less than or equal to lookup_value find the maximum value, Lookup_array must be sorted in ascending order ;
If match_type 0, find the first value is equal to lookup_value, Lookup_array can be arranged in any order; If omitted match_type, the default is 1.
Application examples: Figure 4 shows, in cell F2 enter the formula: = MATCH (E2, B1: B11, 0), confirmed the results returned to find \

reminded: Lookup_array can only be one column or row.
19, MAX function
function name: MAX
main functions: Find the maximum value in a set of numbers.
using the format: MAX (number1, number2 ... ...)
Parameter Description: number1, number2 ... ... representatives to request the maximum value or a reference cell (area), the parameter does not exceed 30.
Example: enter the formula: = MAX (E44: J44, 7,8,9,10), confirmed to display the E44 to the J44 cells and in the region and the maximum value 7,8,9,10 .
to remind: If the parameters are text or logical values, is ignored.
20, MID function
function name: MID
main functions: a text string from the specified position, and the interception of a specified number of characters.
using the format: MID (text, start_num, num_chars)
Parameter Description: text represents a text string; start_num that specifies the starting position; num_chars that number to be intercepted.
Application example: assume that the cell holds the A47 \\
remind: the formula of the parameters, use the English state of the comma \
21, MIN function
function name: MIN
main functions: Find the minimum value in a set of numbers.
using the format: MIN (number1, number2 ... ...)
Parameter Description: number1, number2 ... ... representatives to request the minimum value or a reference cell (area), the parameter does not exceed 30.
Example: enter the formula: = MIN (E44: J44, 7,8,9,10),red wing heritage boots, confirmed to display the E44 to the J44 cells and in the region and the minimum values 7,8,9,10 .
to remind: If the parameters are text or logical values, is ignored.
22, MOD function
function name: MOD
main functions: Find the remainder of dividing two numbers.
using the format: MOD (number, divisor)
Parameter Description: number representative of the dividend; divisor on behalf of the divisor.
Example: enter the formula: = MOD (13,4), confirmed the results show that \
to remind: If the divisor parameter is zero, then the error value \.
23, MONTH function
function name: MONTH
main functions: Find the reference to a specified date or the date cell of the month.
using the format: MONTH (serial_number)
Parameter Description: serial_number on behalf of the specified date, or reference cell.
Example: enter the formula: = MONTH (\
to remind: If the given date, include double quotation marks in English; if you modify the formula: = YEAR (\
24, NOW function
function name: NOW
main functions: given the current system date and time.
using the format: NOW ()
Parameter Description: This function takes no arguments.
Example: enter the formula: = NOW (), immediately after confirmation showing the current system date and time. If the system date and time changed, just click the F9 function key, you can let it change.
reminded: display the date and time format, you can re-set the cell formatting.
25, OR function
function name: OR
main functions: to return a logical value, only if all parameter values are logical \Otherwise, return a logical \
using the format: OR (logical1, logical2, ...)
Parameter Description: Logical1, Logical2, Logical3 ... ...: the conditions to be tested, said the value or expression, up to the 30.
Application examples: In the cell C62 enter the formula: = OR (A62> = 60, B62> = 60), confirmed. If C62 is returned TRUE, A62 and B62 in that at least one value greater than or equal to 60, if the return FALSE, that the values in A62 and B62 are less than 60.
to remind: If you specify a logical condition parameter contains non-logical values, then the function returns the error value \
26, RANK function
function name: RANK
main functions: to return a numeric value in a column in the ranking relative to other values.
using the format: RANK (Number, ref, order)
Parameter Description: Number values to sort the representative; ref numerical order in which the representatives of a range of cells; order on behalf of sort parameters (if it is \ignored, according ranked in descending order, the larger the number, the smaller the value of ranking results; if non-\
Example: If cell C2 enter the formula: = RANK (B2, $ B $ 2: $ B $ 31,0), D 1 can be derived after confirmation of language students in his class ranking in the results results.
remind: In the above formula, we let the Number parameter to a relative reference to the form, and let the ref parameter to the absolute reference in the form (adding a \mouse over the lower right corner of the cell, into thin cross-linear (usually called the \complete ranking scores of other students language statistics.
27, RIGHT function
function name: RIGHT
main functions: a text string from the last character in the beginning, the interception of a specified number of characters.
using the format: RIGHT (text, num_chars)
Parameter Description: text representative of the character string to be cut; num_chars interception of a given number of representatives.
Application example: assume that the cell holds the A65 \characters.
reminded: Num_chars parameter must be greater than or equal to 0, if omitted, the default it is 1; num_chars parameter is greater than if the length of the text, the function returns the entire text.
28, SUBTOTAL function
function name: SUBTOTAL
main functions: to return a list or database subtotals.
using the format: SUBTOTAL (function_num, ref1, ref2, ...)
Parameter Description: Function_num 1 to 11 (includes hidden values) or 101-111 (ignores hidden values) between the figures for What is the function specified in the list with subtotals calculated (Figure 6); ref1, ref2, ... ... on behalf of regional or subtotals to be a reference to not more than 29.
Application examples: as shown in Figure 7, the cells in the B64 and C64, respectively, enter the formula: = SUBTOTAL (3, C2: C63) and = SUBTOTAL103, C2: C63), and will hide the line 61, after confirmation The former appear as 62 (including the hidden rows), which appears as 61, not including the hidden rows.


to remind: If you take automated screening, no matter what type function_num parameters are chosen, SUBTOTAL function ignores any screening results are not included in the line; SUBTOTAL function is applied to the data columns or vertical area, does not apply to row or level area.
29, the function name: SUM
main functions: the calculation of all parameters and values.
using the format: SUM (Number1, Number2 ... ...)
Parameter Description: Number1, Number2 ... ... need to calculate the representative value may be a specific value, a reference cell (area), logical values and so on.
Application examples: as shown in Figure 7, in the cell D64 enter the formula: = SUM (D2: D63), confirmed the language of the score can be calculated.
to remind: If the argument is an array or reference, only one of the numbers will be calculated. Blank the array or reference cells, logical values, text or error values are ignored; if you modify the formula: = SUM (LARGE (D2: D63, {1,2,3,4,5})), you can find the top 5 results and.
30, SUMIF function
function name: SUMIF
main functions: to meet specified conditions for calculating the value and the range of cells.
using the format: SUMIF (Range, Criteria, Sum_Range)
Parameter Description: Range to determine the range of cells representative of conditions; Criteria for the specified conditional expression; Sum_Range need to calculate the value representative of where the range of cells.
Application examples: as shown in Figure 7,red wing heritage boot, in the cell D64 enter the formula: = SUMIF (C2: C63, \.
to remind: If you modify the above formula: = SUMIF (C2: C63, \Because it is text-based, needs to be placed under the English double quotes (\
31, TEXT function
function name: TEXT
main functions: the value specified format according to the corresponding number into text form.
using the format: TEXT (value, format_text)
Parameter Description: value to convert the value on behalf of or reference to the cell; format_text for the specified text in the form of digital format.
Example: If the B68 cell preservation values 1280.45, we enter the formula in cells C68: = TEXT (B68,red wing motorcycle boots, \
reminded: format_text parameters under the \
32, TODAY function
function name: TODAY
main functions: given the system date.
using the format: TODAY ()
Parameter Description: This function takes no arguments.
Example: enter the formula: = TODAY (), confirm that immediately after the system date and time display. If the system date and time changed, just click the F9 function key, you can let it change.
remind: the date format displayed, you can re-set the cell format (see annex).
33, VALUE function
function name: VALUE
main functions: the value of a text on behalf of the string is converted to numeric type.
using the format: VALUE (text)
Parameter Description: text-based representatives need to convert the text string value.
Example: If the B74 cell function is the interception by LEFT and other text-based strings, we enter the formula in cells C74: = VALUE (B74), confirmed, can be converted to numeric.
to remind: If the text type value is not a result of these conversions, the use of the function to deal with these values, often returns error.
34, VLOOKUP function
function name: VLOOKUP
main functions: the first column in the data table to find the specified value, and thus returns the current row in the table at the specified column value.
using the format: VLOOKUP (lookup_value, table_array, col_index_num, range_lookup)
Parameter Description: Lookup_value representatives need to find value; Table_array representatives need to find data in which the range of cells; Col_index_num in the region to be returned table_array match the value of the column number (when Col_index_num is 2, the return table_array values in column 2, 3, the return value of column 3 ... ...); Range_lookup is a logical value, if it is TRUE or omitted, the return approximate match, that is, if can not find an exact match, it returns the maximum value of less than lookup_value; If FALSE, it returns an exact match, if not, it returns the error value # N / A.
Application example: see Figure 7, we enter the formula in cell D65: = VLOOKUP (B65, B2: D63, 3, FALSE), confirmed, as long as the cell B65, enter a student's name (such as D 48), D65 cells showed immediate results of the student's language.
reminded: Lookup_value must Table_array see the first column of the region; if ignored Range_lookup parameters, Table_array the first column must be sorted; the Wizard in this function, the Range_lookup parameter usage is wrong.
35, WEEKDAY function
function name: WEEKDAY
main functions: the date given corresponds to the specified number of weeks.
using the format: WEEKDAY (serial_number, return_type)
Parameter Description: serial_number on behalf of the specified date or dates of that contains the cell references; return_type representation on behalf of weeks [when the Sunday (Sunday) to 1, Saturday (Saturday ) is 7, this parameter is 1; when Monday (Monday) 1, Sunday (Sunday) to 7, this parameter is 2 (this is in line with the Chinese habit of); when Monday (Monday) to 0 , Sunday (Sunday) to 6, this parameter is 3].
Example: enter the formula: = WEEKDAY (TODAY (), 2), confirm the system date is given after the number of weeks.
to remind: If the specified date, please put the English under the double quotes, such as = WEEKDAY (\
one. Select a color effect to the cell form, format - conditional formatting, conditions, select the \


1. interlacing color effect (odd row colors):
= MOD (ROW (), 2) = 1
2. interlaced color effect (even row colors):
= MOD (ROW (), 2) = 0
3. If you want to set the format for each application of a shading line 3, you can use the formula:
= MOD (ROW (), 3) = 1
4. If you want to set different odd and even column shading, as long as the formula of the ROW () to COLUMN () can, such as:
= MOD (COLUMN (), 2)
5. If you want to set chess checkerboard shading (white + custom color):
= MOD (ROW () + COLUMN (), 2)
Description: The conditional formatting formula used to determine the line number and column number and the remainder is divided by 2 to 0. If 0, indicating the number of rows and columns of the same parity, then fill the cell to the specified color, or not filled. In the conditional formatting, the formula results to return a number, non-0 numbers is the TRUE, 0, and the error value is FALSE. Therefore, the above formula can be written as:
= MOD (ROW () + COLUMN (), 2) 0
6. If you want to set the chess checkerboard shading (custom colors + custom color):
add style 2:
= MOD (ROW () + COLUMN (), 2) = 0
II. Color filter can
excel2007 cell color,red wing mens boots, font color or icon to be sorted.
If excel2003, need to add auxiliary column, the name of the method defined by the color of the corresponding number, then the secondary sort column:
color cell in column A, select B1, Insert -> Name - > definition, input a, input the following formula = get.cell (24, $ a1),
this method get the serial number of the font color. B1 enter = a copy the formula down to the appropriate line.
the full table can be sorted by column B. If want to get the background color of the serial number will be changed to 63 to 24.
== \into the name to use
2.Get.Cell (Num, Cell) is the function of the form, Get.Cell can get a cell in a variety of information, such as frame format, etc., Num is specified to obtain the kind of information, 24 out this function is to let the color information unit, taken out after a 1-56 number to represent color number
3. B1 column if you enter your name and fill out the definition, then A1 B1 in the figure is the color code, B2 is A2 in the figure will be the color code, and so
4. Now you press the B column sort, in fact, according to color sort column A the.
attached Get.Cell the meaning of each parameter:
1 refer to the absolute address cell reference cells
2 No.
3 column reference column number cell similar
4 TYPE function
5 with reference to the text contents of the address
6 shows the light formula
7 with reference to the address format of the address, text display text display
8 format
9 with reference to the address to return extra storage box left style, figures show
10 extra storage box on the right to return the style, the figures show
11 store extra return on the style side box, digital display
12 frame side return the extra storage under the style, number of Show
13 returns the internal drawings, figures show
14 locked if the cell is set to return True
15 is hidden if the formula returns True
16
returns the width of the cell 17 points as the unit returned to the cell height
18 point font name
19 to return the font size for the unit cell all
20 or if a character is bold return True
21 If all or a cell in italics the first character returns True
22 If all or a cell first character is a single bottom line returns True
23 if the cell or the first characters of all the middle of a horizontal line font Returns True
24 returns the first character color cell number, 1 to 56. If set to automatic, returns 0
25 MS Excel does not support the outline format
26 MS Excel format does not support the shadow figures
27 insert page breaks manually set the outline of the column
28 Outline of the field-level
29
30 if the level of the outline summary of the range compared to True
31 if the range is the outline of the summary column was True
32 shows the workbook and worksheet name of the
33 If the cell formatting for multiple lines of text compared to True
34 extra storage box on the left to return the color, figures show. If set to automatic, returns 0
35 extra storage box on the right to return the color, figures show. If set to automatic, returns 0
36 extra storage box at the top to return color, figures show. If set to automatic, returns 0
37 return save extra box below the color, figures show. If set to automatic, returns 0
38 cells future returns shadow colors,red wing heritage, figures show. If set to automatic, returns 0
39 returns the cell back shadow color, figures show. If set to automatic, returns 0
40 text display cell style
41 returns the address of the original equation reference
42 points as the unit returned to the use of the left window on the left to the level of cell Distance
43 in points in the top of the window to return to using the cell above the vertical distance
44 in points in the window on the left to return to the use of a cell to the right of the horizontal distance
45 points unit returns to the top of the window used in the cell below the vertical distance
46 are inserted comments if the cell returns True
47 if the cell has to insert a sound prompt return True
48 are inserted into the formula if cell Returns True
49 if the cell is an array formula returns the range of returns True
50 cell vertical alignment, the figures show
51 perpendicular to the direction of the cell returned, figures show
52 pass back to the cell prefix character
53 text display shows the contents of the cell returned
54 returns the name of the PivotTable cell
55 returns the cell in the PivotTable pivot position
56
57 If all or a cell first character is superscript text return True
58 shows return of all or a cell font style
59 characters return the cell bottom line style, the figures show
60 If all or a cell for the first character subscript returns True
61 pivot
62 shows the workbook and worksheet name
63 returns the fill color of a cell mass
64 Back to the drawing foreground color
65 pivot
66 shows the workbook name

[ug6bt0zh4cg]

| Back to logs list

2126141 2010 年 06 月 18 日 11:06 Reading (loading. ..) Comments (0) Category: Personal Diary
the beginning of dollars articles

Sun Zi said:
soldiers who affairs of state of life and death, the survival of the Road, must be aware also.
it to five by the matter of school to take account of, and claims the situation: one said channel, second is days, the third is, the Si Yue will be the five
said method. Tao, so that people in the last agreed to die with them, with which students can not risk him; days are the yin and yang, cold and heat
, when the system has; to those near and far, risks Yi, Guang Xia, and death also; the person, intellect, faith, benevolence, courage, strict also; method
those music system, the Guan Dao, the main use it. Where this five, they will be heard all working, knowledge of who wins, I do not know the person victorious. Therefore, the school
of the total, while the index of their situation, saying: Lord what proper way? There will be what? What was heaven and earth? Order what line? Strong public what soldiers?
his soldiers what to practice? What out rewards and punishments? I know the outcome of this carry on. Will listen to my count, with the win, leaving them; will not listen to my account
, doomed to failure used to it.
total interest to listen to, is worth the potential to rank and file out of it. And powerful, has the right to take advantage of the system. Soldiers who deception too. It could be said of
and can not, do not use the show of the past and show the far, far and show the close. The lure of profits, chaos and taken from, real
the preparation of, strong without fear, anger and scratch it, humble and proud of, lost the labor of, and away from the parent, focusing on non-prepared, out of its
unexpectedly. The military commander of victory, not the first pass also.
husband did not fight the winner of the temple operator may also count more; not count numerous battle of the temple, who was considered too small. Less multi-operator wins count,
and conditions with no operator peace! I this perspective, the outcome see the carry on.

grandson said operational Posts

:
where military forces of the law, Autopia thousands Si, Ge Qian Cheng car, with a hundred thousand, a thousand miles fed grain. The inside and outside of the fee, guests
use, plastic paint the material, the instructions from a vehicle, at fees daughter, and then hundreds of thousands of teachers held carry on.
use of warfare, victory is a long sharp blunt military setbacks, siege, the force bent, long division, the country with the lack of violence. Sharp blunt soldiers frustrated husband,
flexor force exhaust goods, then the princes by disadvantages into the sky, though the wise can not be good then carry on. So Wen Zhuo Bing-speed, long
not see too clever. Fu Bing Lee long and the country who are also not of. Therefore, not the military forces of the victims know, you can not make use of forces of interest to know also.

use of soldiers who served no nationality, no three-contained food, take for the country, because of grain on the enemy, so the military can be enough food also.
Poor country lost on the teachers are far, far lost the poor people; nearly teachers are Guimai, Guimai the people of wealth have dried up, dried up the rush hill fiscal reserve.
force bent the Central Plains, the virtual at home, the people of the fee, ten to the seven; public of the charges, the military strike breaking horses, armor arrow bow and halberd, spear and shield
Lu, Qiu cattle carts, ten to the VI. Therefore, food services in Chile will be the enemy, the enemy eating a bell, when I twenty minutes; □ ① bar
one stone, when my twenty stone. Therefore, those fighting the enemy, angry also; take the enemy's interests are, cargo also. Car wars may take more than ten vehicles, tours and more
the basis of their flags are. Hybrid cars and ride it, and keep the good soldier, while the benefits are strong that the enemy wins.
so precious in wins, not expensive for a long time.
refresher soldiers will, the people of the Siming. National security of the Lord.

【Note:】
①: \

plan of attack articles

Sun Zi said:
husband military forces of the law, the country is on the second break the country; army is on breaking the military, followed by; the whole trip is on
break the trip; death is on the whole, broken, followed by death; the whole Wu is on break, followed by Wu.
Therefore in victorious, not good to do good; the enemy without fighting the soldiers, the good and good also. Therefore, the Bing Fa Mou,
times its cross-cutting, followed by cutting forces, under siege. Siege of the law, as a last resort. Xiu Lu □ ① □ ②, with equipment, three months and then into
; from the mound, and then in March has been. Ants to cope with their anger and attached, to kill his soldiers one third of the city who do not
pull this attack of the disaster also. Gushan use of troops who subdue the enemy rather than warfare, rather than attack the city of pulling people have ruined the country and not for a long time
person also, shall be in full competition in the world, so the soldiers can not Washington and Lee all, The law also seek for the attack.
so military forces of the law, ten Wai, five for the attack, fold the points, you can fight the enemy, at least able to escape it, if you can not
avoided. Therefore, the small firm the enemy, the enemy of the capture also.
husband will who also assisted country. Fu Zhou Zeguo will be strong, auxiliary gap, the country will be weak. Gu Jun in the military who suffered third reason:
I do not know the military can not turn into that of, I do not know that the military should not retreat the retreat, is that the Mi Army; I do not know the three services of the armed forces of the same things and
governance, the sergeant carry confusion; I do not know the three services of the armed forces of any of the same right, the sergeant doubt carry on.
Confusion and doubt both armed, the princes of the hard Zhiyi. Is that the victory for creating chaos.
refresher win five: knowledge can not fight war with who wins, use knowledge Zhonggua wins, wins up and down with the desire to be unexpected
Yu wins, will win the monarch did not Yuzhe . The five who also know the road win. Hence we say: Know thyself
not battle-Yi; I do not know he and close friend, and one win and one loss; I do not know he is not friends, no win every battle.

【Note:】
①: [car Ben].
②: \

shaped articles

Sun Zi said:
past the warriors who can not be the first to win, to be the enemy to win. Can not win in himself, can win the enemy. So skillfully are
, can not win, can not make the enemy will win. Hence it is: win shows, but impractical. Not the winner, keep also;
be the winner, attack also. Code deficiencies, are more than attack. Good to keep those hidden in the under nine, good attack were fixed in nine days on
, it can protect themselves and the victory also. See win, but you all know, the good and not too good; over the world said good, the good and non-
good also. Not to give it more power in autumn, see the sun and the moon is not as eyesight, smell is not for the ears and Thunder. The so-called good old war who
, easily better than the winner also. Therefore, the wins and skilled persons also, lack of wisdom were, no courage power,belstaff leather, so the defeat is not Intuit. Intuit who do not
, it measures wins, wins have been losers as well. So skillfully are invincible, and yet the enemy also lost. Victorious soldiers
Qiuzhan first victory and then, while defeated warriors go to war first and then to win. Use of soldiers who cultivate and Protection Law, it is for victory or defeat of the government.
art of war: one said degree, second is the amount, third is the number of Si Yue said Wu Yue wins. Degrees to students, du volume, the amount of raw numbers
, the number of students that said the students win. Peter said if it wins soldiers baht, while defeated warriors go if baht, said Yi.
people also said the war winner, if the decision a thousand yards of the river water in those shapes too.

potential of

Sun Tzu said:
few who rule the public, such as governance, scores is also; Doo Doo the public, such as few, form name is also; the three services of the public, will be the enemy can The
no losers, it is also odd; soldiers are added, such as the egg □ ① vote who is also the actual situation.
any war who, in exact order Clipsal. Gushan who surprisingly, infinite as heaven and earth, inexhaustible as Jianghai. Undone before the end
, sun and the moon is also. Rehabilitation death seasons is also. Sound only five, five sound of the change, and hearing they can not win; colors, but Five
, five colors of the change, can not win concept also; taste, but five flavors of the change, can not win try also; the military situation is surprising, however, odd
is the change, can not win the poor also. Qi is with students, such as the cycle of no reason, Practice makes the poor of the holy!
bowel disease of water, as those boulders, potential also; the fowls of the disease, as to destroy off those sections also. So skillfully, their
potential risks, the section is short. Such as the potential expansion of crossbow, sections such as hair dryer. Have Yunyun, chaos and can not fight chaos; muddy chaos chaotic, round-shaped and can not defeat
. Born in chaos rule, was born in Yong cowardly, weak, born strong. Combat confusion, a few are; courage of confidence, the potential also; strength, shape
also.
Gushan moving enemy who, in the form of the enemy from God; to it, the enemy will take it. To facilitate moving to finally be it. Gushan
war who help of trend momentum, it is not responsible for the human person can choose any situation. Any potential, their war people, such as wood and stone transfer. The nature of wood and stone
, Anze Jing, risk is dynamic, square is only round the line.
so skillful trend of people, such as genetically boulders on the mountain were a thousand yards, the potential also.

actual situation Posts

Sun Tzu said:
who asked to be the enemy who at the field and Lost, while the trend after the war were at the field of labor. So skillfully are, cause they would not people. Since the enemy to those who can
, Lee Chih; make the enemy not to persons, victims of too. Lost it to workers of the enemy, full of energy hungry
, the dynamic of security. That it will be increasingly, increasingly it unexpectedly.
traveling thousands of miles without the workers who is also the line in the no man's land; attack and will take those attacks do not keep it too. And who will be solid defensive
, they will keep attacking as well. Gushan attacker, the enemy did not know they keep; good keepers, I do not know their enemy attack. Almost almost micro-micro,
As for the invisible; God from God almost, as silent, and it could be an enemy of the Siming. Then not Yuzhe, red is also the virtual; back
and can not recover those, and also speed and can not. So I want to fight the enemy, while high barrier deep groove, who had to fight with me, attack their
will save him; I do not want war, although the painting to keep the enemy who can not fight with me, it s good also. It shaped who I am without
shape, I designed the enemy points. I for one, the enemy is divided into ten, ten is one attack too. Public enemy is my widow, able to hit all
few persons, the passions, which were about carry on with the war. Wu Suo and combat land unknown, unknown who is the enemy of the equipment more than the enemy who are more prepared
, the Wusuo carry on with the war are few. Therefore, the latter prepared by former scarcity, for later in the preceding few, few on left then the right, the right equipment is left
few, nothing is prepared, no do not widowed. Few persons, who were also prepared; all those people who have been prepared. Land warfare refresher
, know the day of battle, the battle may be thousands of miles; I do not know the land of war, I do not know war days, you can not save the right of left and right can not save
left, the former can not be saved, the post can not save before, and conditions were far from dozens of years, recently, a few years almost!
to my degree, the more the soldiers, although many also benefit from the win Zai Xi!
twenty years before: win can be also. Although the public enemy, can not fight. Therefore, the plan for making the conceivable gains and losses, with knowledge of the movement of
designate management, the conceivable form of life and death, the angle makes me know more than weaknesses. Therefore, the extreme form of soldiers, as invisible. Between the invisible dark can not glimpse the
, the wise man does not seek. Shape and measures rather than by the public, the public can not know. I so win who knows that the shape, and so I
Mozhi Winning form. So the beat no longer, but should be shaped in the endless. Fu Bing
image of water, avoid the high water line of trend, the soldiers hit form to avoid the real and imaginary; water flow due to the system, soldiers and victory for the enemy
. Therefore, the potential impermanence soldiers, the water is uncertain shape. Can change because of the enemy to win those, that the God. Therefore, the five elements becomes a Buddha,
pm uncertain position, long or short day, month, a life and death.

military struggle articles

Sun Tzu said:
where the military forces of the law, the orders from the king, gathered together the military, diplomacy and the homes, Mo difficult military struggle. The difficulty of the military who fight,
to migrate straight to suffer into an advantage. migrate its way
it, and entice the benefit of others and hair, their ancestors to this the plan for those who know Yuzhi also. Order to facilitate the military struggle, the military struggle for the crisis
. Give the military and not for profit and the appointment of army and baggage for profit is donated. Therefore in the paper a trend, not at night, times
Road and the line, Barry and for profit, then capture three generals, fresh, first, exhausted by, its law and to the eleven; fifty in the competition
Lee,belstaff outlet, you stumble on the general, half to the law; ten miles and a scramble for profits, the two-thirds to. Therefore in the military without baggage will die,
without food will die, no commissioned product will die. Princes of the plan so I do not know who can not pay Yu; I do not know the mountains, obstacles, Ju Ze
of shape, can not march; not township guide who can not get location. Therefore, in order to soldiers fraud legislation to facilitate the move to those points and also for the change
. Therefore, its lightning-fast winds, and their Xu Rulin, invaders like fire, do not move like a mountain, it is difficult to know, such as yin, moving as Lei Chen. Swept Township
divided, sub-profile to benefit, suspended the right moves. Prophet Yuzhi the total wins, the military struggle of the law also.
\Only specific people are not alone into the brave, cowardly retreat shall not alone in this with all the
law also. Therefore, multi-Ku night combat, day war more flags, so the eyes and ears were also changed.
army may seize gas, the generals can seize the heart. Therefore in sharp energetic, inert gas day, apathy return. Use of soldiers who, to avoid the sharp
gas, hit the idle return, the government gas among them. The rule to be arbitrary, to wait for Wow, who is also the heart of this rule. Nearly to be far away, to be Labour Lost
to eat until hunger, the government forces those who are. No invitation is precisely the flag, without imposing the hit Chen, who is also the rule change.
so military forces of the law, Gao Ling not to, do not back against the hill, pretend not from the north, Ruicu do not attack, bait Bing Wu Shi, in the final division not
containment,belstaff jackets outlet, confining Shiyi Que, tottering foe not to force, this military forces of the law also.

nine Pandemic

Sun Tzu said:
where the military forces of the law, the orders from the king, joint military polymerization. Pan to no homes, Qu to co-pay, no leave the Jedi, is seeking around to
, kill the war, the way has not help, the military has not hit, some do not attack the city, to be indisputable, Junming there The
not.
it will pass on the nine variables of interest who know military forces carry; will change the profit barrier nine, though know the terrain, can not get to carry on the benefits
; Zhibing I do not know the art of nine variables, although the five interest to know can not have people use carry on.
Therefore in the considered wise, will be mixed in the interest, miscellaneous and service credibility is also at the benefit, harm and suffering in hybrid can be separated. Therefore in order to harm those who bend
princes, princes who served in industry, the trend princes were to benefit. Therefore, military forces of the law, no it does not come to rely, rely
I have to treat it; not rely it does not attack, I have not attack relies too.
it will have five danger, death can be killed, is bound to produce to Krupp, the anger-speed can be insulted, and honest to shame, Oi can be annoying. Where this five
, they will be at fault also, military forces of the disaster also. Will cover the military to kill, will be a five-crisis, must be aware also.


march Posts

Sun Tzu said:
at the military phase where the enemy must Hill by Valley Health Department, as the high non-Teng Long War, where mountains of the Army . Water will never distant water,
water must come off, do not welcome is to the water within, so that crossing the strike of half-profits, like war, those with no attached to the water and welcoming, as the Health Department
high No welcome water, where water of the Army. Never denounced Ze, the only non-urgent to stay, if cross into the armed forces denounced Ze, but will be back by
plants the trees, where the Army Ze exclusion. Flat land is fragile, right back high before the death of Health, where flat land of the Army
. The above activities and benefit from the Fourth Army, Emperor Huangdi also the reason why four wins. Where the evil army under a good high, Guiyang and cheap Yin, and health while at the
fact, the military without a hundred diseases, is that win. Hilly embankment, while the right will be at the back of the sun, the soldiers of the benefits, to the help also.
on the water flow to, like those involved, let it be also. Where to have the absolute stream,belstaff jacket, patio, Tianlao, day Lo, the day depression, days gap,
will go to the urgent, not nearly as well. I distanced the enemy near them; I welcome it, the back of the enemy. Army next to obstacles, Huang wells Jianjia
, Kobayashi, □ ① Hui who will wish to cover the cable, the underlying evil of which are.
near the static enemy who relies on the Risks; far the challenger into the person want to have; they DrayTek who benefit also; all the trees
actors, to have; all the grass and more impaired suspicion of him; birds from those V also; beast hack who follow him; dust were high and sharp, the car
to him; base and wide who only come to him; scattered over the bar who also collected firewood; few and between those camps Army; speech Peel and prepare
who enter also; words were strong and into the drive, back also; light rail vehicles, first-out home of their side who, Chen also; not about the requested and who plan also
; running the Bing who, on him; half into a half back who lured him; stick standing who are hungry; drain first and drinker, thirsty also
; see the benefits rather than entrants, workers also; birds are sets, virtual also; night call who fear him; military interference, then it will not fall again; flags
actors, revolt; Officials anger, tired also; kill the horse meat eaters, the military without food also; hanging □ ② not return to their homes who tottering foe also
; earnest □ ③ □ ③, Xu and others speakers, the public has lost; few tours who embarrassed him; the number of those penalties, difficulties also; the first storm and then
aversion to the public who do not fine matter to it; to thank the Committee who want to rest too. Bing anger greeted a long time and the sub, not much difference
, the police will move.
soldiers, numbers of non-expensive, no advantage, enough to lie at the root Liaodi the person from it. However, easily understood without taking into account the enemy husband who will capture
to others. The penalty of death is not pro, then refused to accept, difficult to use against you. Death penalty is not pro-attached and is not available. Therefore, the United
to the text, together by force, is that will take. Order Suxing to teach its people, the public service; orders not to teach the people factor, the
against the people. That element entrants, and the public Xiangde also.

terrain Posts

Sun Zi said:
terrain pass by, to hang those who have supported, there are narrow those who have insurance, who have much. I can go, he can
years, said Tong. Pass shape, high in the first Yang, Lee grain Road to War is profit. Can go, it is difficult to return, said hanging. Linked to form
who the enemy is unprepared, out of the victory, the enemy if prepared, out victorious, it is difficult to return, negative. I'm out of the negative, he out
and negative, said support. Branch shape, although the enemy benefit me, and I have not come out, the lead away to make out and attack the enemy half-interest. Ai
shape, I should his residence, will profit of pending enemy. If the ranks of the enemy first, profit Erwu from, do not profit from it. Risks to shape,
of my first home, will be home to the enemy Goyang; if the first ranks of the enemy, away the lead, not from the can. Much to shape, are difficult to
potential challenge to fight a disadvantage. Where this six persons, to the road also will matter to any, must be aware also. All soldiers who have gone
have Chi those who have depression, who have collapsed, there is chaos, others to North. Where this six, non-World
the disaster, will be at fault also. Potential husband were to strike ten, said to go; Death strong weak officials, said Chi; Officials strong pawn is weak, said depression;
Dali angry and dissatisfied, Yudi hate war and since, will not know its capacity, said collapse; the weak lax, Religion and unknown, Lizu no
often, Summary of the horizon, said disorder; will not Liaodi to less Triangle to hit the weak strong, non-elected military front, said North. Where this
six who lost way too, will matter to any, must be aware also.
terrain husband who can help soldiers. Liaodi winning, namely Xianai distance, the road will be also. Who must know this and use the war
wins, I do not know this but with war comes before a fall. Battle Road win it, the Lord said, no war, war will be also; Road victorious war, the Lord said, will
war, no war can be too. It into not seeking the name does not avoid back offense, the only people is Paul, and conducive to the Lord, a national treasure.
such as infant death, it can work with to go to the stream; as death, such as son, it can be with them all die. Thick can not make,
not make love, chaos and can not rule Piruo pride, not use it. Death of
Zhiwu can hit, but I do not know the enemy can not attack, and beat half also; know the enemy can strike without Zhiwu death of
can not hit, and beat half also; know the enemy can strike , Zhiwu death of can hit, but I do not know the terrain of not war, wins half of
also. Refresher soldiers who move without the fans, move without the poor. Hence it is: Knowing your enemy, friend, your victory will not be threatened; Know the weather, know the terrain
, victory will be full.

to articles

nine grandchildren said:
military forces of the law, there are scattered places, with light to, a struggle to have to pay to, a thoroughfare to have powerhouse, a pan- to have
around to have death. Since the war the land lords who, as a casual manner; not deep into the land of people who, for the light to; I have to also benefit,
Peter, who also benefit, as the struggle to; I can go, he can come by, as surrenders; feudal land of three genera, Xianzhi derived
world public who, for the way thoroughfare; deep into the land of people, cities and more are back for the powerhouse; mountains, obstacles, Ju Ze, where hard
line of the Tao, the Pan-land; are run into those narrow, the migration from the homeless, he has few of the public who can hit my order around in; disease
war is to survive, fight disease is not dead, as death. Therefore in bulk to no war, no light to stop, competing for no attack, no absolute cross
way, thoroughfare to the Stock Exchange, powerhouse is swept, the pan to the line, around to the plan, death the war.
Gu Zhishan military forces who, before the enemy can not phase and, Zhonggua incompatible rely, are equal do not rescue, do not up and down relative to income
, and death rather than from the set of joint forces and not homogeneous. Moving together in the interest, are not in the interests full length. Dare to ask the public enemy, and the entire future, to be
of Ruo He said: wins their first love is listening to carry on. Soldiers love the main speed, take less person. By the unexpected way, they do not attack
ring also.
off the road where the depth is special. Owner not be able to, swept in wild Rao, armed enough to eat. Would like to raise Erwu labor, and product gas
force, personnel carriers trick for the unpredictable.
nothing to throw the dead and not the North. Yan shall not die, scholars do. Depression is very afraid of the soldiers, nothing to the solid
, depth is arrested, then forced to fight. Therefore in the military does not repair the ring, no derived, not about the parents, do not make the letter,
Ban Xiang to suspect, nothing of death.
I who it demonstrated financial, non-evil goods also; it demonstrated life, non-evil life also. Order issued the day, his soldiers seated tears s garments, Yan Yi
lying by tears make, nothing to throw, Zhu, Gui of courage. Gushan military forces who, for example Shuairan. Lvran who Changshan
of snakes. Its first to hit the tail, is the first to hit its tail, then the sum of all of them to hit. Dare to ask the soldiers if Shuairan can almost
? Can be said. Fu Wu Man and more of people's bad too, when the same boat and the economic and the case of wind, but also as its right hand is extended. Therefore in horses buried side
round, not enough to rely too; Qi Yong as one, the government way too; Rigid Chieh-te, to the management also. Gushan military forces who carry
subject the one hand, a last resort also.
general matter, to quiet quiet, is to cure, to fool the eyes and ears of his soldiers, so ignorant; easy to the event, reform of its plan,
makes no education; changes of the home, migrating their way, so that People may not consider. Handsome with it on, such as climbing the ladder away; handsome princes with whom deep
into place, and made the machine. If the drive sheep, drive and go, drive from, Mozhi by it. Together the three services of the public, to vote
of the risk, what we called the general things too.
nine to the change in flexion and extension of the power of human reason, must be aware also.
where the passengers of the Road, Shenzhen is designed, light is scattered. Cross-border and teachers are out of the country, the Jedi are; four Toru who Qu to have;
into the deep who powerhouse also; into the light who is also lightly; back were solid before the narrow, confining places also; nothing to those who of death also.
Therefore in bulk to happiness of a chi, so that is a light to Wu Jiang, Wu Jiang increasingly competing for subsequent delivery to Wu Jiang would like the keep,
solid happiness of the cross to its end, Qu to Wu Jiang would like the dependable, powerhouse happiness of following their food, their way into the pan to Wu Jiang, Wu Jiang
around to plug the palace to kill the happiness of the show is not live.
soldiers love it: around the defense, and forced the fighting, over from. Therefore in the plan
princes who do not know, can not be prepaid; I do not know the mountains, obstacles, Ju Ze of shape, can not march;
not rural guide, can not be geographical. Four or five persons, one I do not know, not King of the soldiers also. King of the soldier husband, cutting power,
then the public may gather; Weijia the enemy, their pay shall not be combined. Therefore in the world do not compete at the turn of the right thing in the world do not support the letter
our own private, Weijia on the enemy, then the city can pull out, the State may destroy.
facilities can not be the reward, no government suspended the order. Guilty of the three services of the public, subject the person. Guilty of the thing, do not tell the words; committed
of the victims, do not tell the benefit. Then vote to keep the death, the death trap and students. Husband caught the public harm, and then be able to win
defeat.
it is a matter of soldiers, the enemy in detail the meaning of Shun, and the enemy has always been, will kill thousands of miles, is that clever hosts. Therefore in the day
political move, Yi Guan break off, no pass its so, Li in the ############## above the temple, to punish the case. Opening and closing the enemy, must urgently into the first
their love of micro-contrast, practice with the enemy ink to do battle. Therefore in the beginning such as the virgin, the enemy opening; post such as rabbits,
less resist the enemy.

Fire Attack articles

Sun Tzu said:
where Fire will have five: one person said the fire, second is the fire product, third is the fire y, Si Yue fire, library, Wu Yue fire team.
there must be a result of the fire line, as will be a factor. Sometimes angry, fire a day. When those days are dry. Days, months in
Kei, wall, wing, Zhen also. The above activities were four places, the wind from the day also. Where a Fire Attack, will change because of five should the fire: the fire occurred in the
is long overdue is to the outside; fire sent its soldiers were quiet until the Erwu attack, extremely fire can be so from the, from then on not
. Fire can be made on the outside, no question in the order is issued when the fire made the upper hand, no capture of the wind, the wind a long day and night
wind only. Five military must know where the fire of change, in order to keep the number.
Junior attacker so the fire out with water junior attacker strong. Water can never, can not be won.
husband took it over but not idle power by its fierce, Ming Yue \Hence it is: the next main consideration, good will be inert, the non
fixed interest, have to do, non-crisis without a fight. Xingshi not anger the Lord, will not be indignant and necessary condition for battles.
Together in the interest and action, inconsistent with the previous benefit. Anger can be re-hi, resentment can be complex, said complex can not be kept subjugated, not the dead back to life
. Therefore, the next main caution, warning of good will. The road to Yasukuni army also.

alienate Posts:

Sun Tzu said:
who Xingshi million, and set off thousands of miles, the people of the fee, the public sector of Feng, the daughter of day rates, internal and external disturbances, lazy road
Road, not things are operating, seven hundred thousand. Spend several years in order to compete win, and Love Peerage hundred gold, I do not know who the enemy situation
, heartless matter to it, Africa and China is going to have, not the Lord of the rank and file also, can not win the primary. So it could maintain the action and
Yin wins, successful out of all those prophets. Prophets, not desirable in the spirits, not like at all, not experience in the degree of
, will take on the people who know the enemy situation also.
so with five rooms: a result, the rooms are inside, there are anti-room, there are dead, the animate rooms. All five, the Mozhi its
Road, is that the discipline of God, The ruler of the treasure. Country who,belstaff sale, because of the use of local people; in between those, because Husband and used
; discord among those between the use of their enemy; death among persons, things to deceive the outside, so I have heard knowledge of the transfer between the enemy also; Health
among those reported to have anti-. Therefore, the three services of the things in between pro-Mo, Mo thickness in the reward, the matter density in Mo, the non-sage can not be used
, the non-benevolence is not so, the non-subtle not have room in reality. Micro-micro-zai zai! There is also nothing to do. Do not send
between the first and the listener, who, among those with the report and death. Where is the voice of the military strike, the city of the Yu Gong, one of the Yusha, we must first know these
defender, left, Yezhe, door persons, Scheeren name, so I will claim to know the room. Between the enemy to those who asked me, so
benefit of, and the homes of lead, so use it against inter-Ke Deer; reason is wise or home, the inner room Ke Deer so also; because
is with knowledge Therefore, to lie among dead things, can tell the enemy; reason is with knowledge, so students can schedule rooms. Five things,belstaff online,
the Lord will know it, know the will is the anti-room, it is not no room Anti-thick also.
Xi Yin Hing also, loved Iraq in the summer; weeks Hing also, in the Yin Lu teeth. It could maintain Yin will be able to Chile was among more than those
, will become the great service. The soldiers want to, relies on the three services of the moving also.