аЯрЁБс>ўџ MOўџџџLџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџьЅС5@ №П "bjbjЯ2Я2 (0­X­Xу)џџџџџџˆшшшшшшшќ$$$8\xќƘц~””Ќ‡‡‡…‡‡‡‡‡‡$МRšЋш‡‡‡‡‡Ћшш”ЌлРїїї‡ш”шЌ…ї‡…ї:ї1шш1”Œ № …кЃТ$1…ж01ЈГ.Ј1ќќшшшш1ЈшE@‡‡ї‡‡‡‡‡ЋЋќќD@ фсќќ@ Examples of commonly used formulas Common Conditional  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlCheckIfGreater.htm" Check if a number is greater than or less than another number  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlconCondFormulas.htm" Create conditional formulas by using the IF function  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xldecDisplayOrHideZeroValuesOrOtherCellData.htm" Display or hide zero values  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlconAboutLookingUpValuesInLists.htm" Look up values in a list Common Date and Time  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlAddDates.htm" Add dates  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlAddTimes.htm" Add times  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlCalcDateDiff.htm" Calculate the difference between two dates  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlCalcTimeDiff.htm" Calculate the difference between two times  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlConvertHoursFormat.htm" Convert times  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlCountDown.htm" Count days before a date  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlJulianDate.htm" Insert Julian dates  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlInsertDateTime.htm" Insert the current date and time in a cell  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlShowDaysWeek.htm" Show dates as the day of the week Common Financial  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlRunningBalance.htm" Calculate a running balance  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlMultiplicationTable.htm" Create a multiplication table Common Math  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlAddNumbers.htm" Add numbers  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlCalcAverage.htm" Calculate the average of numbers  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlPercentDiff.htm" Calculate the difference between two numbers as a percentage  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlCalcMedian.htm" Calculate the median of a group of numbers  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlCalcSmallNum.htm" Calculate the smallest or largest number in a range  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlConvertMeasurements.htm" Convert measurements  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlCountNumCells.htm" Count cells that contain numbers  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlCountNumGreaterThan.htm" Count numbers greater than or less than a number  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlDivide.htm" Divide numbers  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlHideErrorValues.htm" Hide error values in a cell  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlIncreasePercent.htm" Increase or decrease a number by a percentage  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlMultiply.htm" Multiply numbers  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlRaisePower.htm" Raise a number to a power  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlRoundNumber.htm" Round a number  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlSubtract.htm" Subtract numbers Common Text  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlChangeCase.htm" Change the case of text  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlCheckIfText.htm" Check if a cell contains text  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlCombineFirstLastNames.htm" Combine first and last names  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlhowAddSpecCharNum.htm" Combine text and numbers  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlCombineTextDate.htm" Combine text with a date or time  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlCompareCells.htm" Compare cell contents  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlCountNonBlank.htm" Count nonblank cells  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlRemoveCharacters.htm" Remove characters from text  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlRemoveSpaces.htm" Remove spaces from the beginning and end of a cell  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlRepeatCharacter.htm" Repeat a character in a cell  HYPERLINK "mk:@MSITStore:C:\\Program%20Files\\Microsoft%20Office\\Office10\\1033\\xlmain10.chm::/html/xlCountConditionMultiple.htm" Count unique entries in a list Commonly Used Formulas.doc  PAGE 2 #67ДЕђѓєѕs t Ј Љ Њ Ћ C D _ ` a b я №   — ˜ Ё Ђ Ѓ Є   % & ' ( Ѓ Є Ю Я а б L M w x y z ћ ќ    „…žŸ -./0­ЎийклVWxy‹Œ  %&'(ЊЋШѕёщёщущёщёщущёщёщущёщёщущёщёщущёщёщущёщёщущёщёщущёщёщущёщёщущёщёщущёщёщущёщёщущёщёщущёщёщу h•b50Jjh•b5Uh•b5h•b5h•b5CJ$aJ$Z#6єЊ a  Ѓ ' а y Ÿ/кz‹'Ъж^ќЖ]ЉIџњѕ№№№№ѕ№№№№№№№№№ѕ№№ѕ№№№№№№№№gd•b5gd•b5gd•b5у! "ўўШЩжзPQ\]^_йкњћќ§wxДЕЖЗ01[\]^йк ’“ЇЈЉЊ&'GHIJЬЭ§ўџuv„…†‡!"#$ЂЃабвгJK[\]^зиёђѓєno}~€їј їѓїѓїэїѓїѓїэїѓїѓїэїѓїѓїэїѓїѓїэїѓїѓїэїѓїѓїэїѓїѓїэїѓїѓїэїѓїѓїэїѓїѓїэїѓїѓїэїѓїѓїэїѓїѓїэїѓїѓїэїѓїѓ h•b50Jh•b5jh•b5U^џ†#в]ѓ ЊEщ…'ЛOэž *phџ4@4 „SJHeader  ЦрР!4 @"4 „SJFooter  ЦрР!.)@Ђ1. „SJ Page Number  0 џџџџ#6єЊa Ѓ'аy Ÿ/кz‹' Ъ ж ^ ќ Ж ]  Љ Iџ†#в]ѓ ЊEщ…'ЛOэž<у  0€€(0€€p˜0€€˜0€€˜0€€˜0€€(0€€˜0€€˜˜0€€˜˜0€€˜0€€˜˜0€€ €˜0€€˜0€€˜0€€˜0€€(0€€˜0€€˜˜0€€ €(0€€˜˜0€€ €˜0€€˜˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€(0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€ˆ@0€€ј€My0а 8_ƒ#6єЊa Ѓ'аy Ÿ/кz‹' Ъ ж ^ ќ Ж ]  Љ Iџ†#в]ѓ ЊEщ…'ЛOэž<Ўz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЎz0аЌz0€Ќz0€š€€emk:@MSITStore:C:\Program Files\Microsoft Office\Office10\1033\xlmain10.chm::/html/xlCalcTimeDiff.htmh6emk:@MSITStore:C:\Program Files\Microsoft Office\Office10\1033\xlmain10.chm::/html/xlCalcDateDiff.htm|1amk:@MSITStore:C:\Program Files\Microsoft Office\Office10\1033\xlmain10.chm::/html/xlAddTimes.htmt8 amk:@MSITStore:C:\Program Files\Microsoft Office\Office10\1033\xlmain10.chm::/html/xlAddDates.htmO wmk:@MSITStore:C:\Program Files\Microsoft Office\Office10\1033\xlmain10.chm::/html/xlconAboutLookingUpValuesInLists.htm?h‚mk:@MSITStore:C:\Program Files\Microsoft Office\Office10\1033\xlmain10.chm::/html/xldecDisplayOrHideZeroValuesOrOtherCellData.htm\hmk:@MSITStore:C:\Program Files\Microsoft Office\Office10\1033\xlmain10.chm::/html/xlconCondFormulas.htmYgmk:@MSITStore:C:\Program Files\Microsoft Office\Office10\1033\xlmain10.chm::/html/xlCheckIfGreater.htm ўџџџ ўџџџ"#$%&'()*+,-ўџџџ/012345ўџџџ789:;<=>?@ABCDEFGHIJKўџџџ§џџџNўџџџўџџџўџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџRoot Entryџџџџџџџџ РF0.ˆкЃТP€Data џџџџџџџџџџџџ1Tableџџџџ!ЈWordDocumentџџџџ(0SummaryInformation(џџџџџџџџџџџџ.DocumentSummaryInformation8џџџџџџџџ64+CompObjџџџџџџџџџџџџjџџџџџџџџџџџџўџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџўџ џџџџ РFMicrosoft Word Document MSWordDocWord.Document.8є9Вq