Excel Is Simple

Description The IF function returns one value if a condition you specify evaluates to TRUE, and another value if that condition evaluates to FALSE. Syntax The IF function syntax has the following arguments: logical_test: Required. Any value or expression that can be evaluated to TRUE or FALSE. For example, A10=100 is a logical expression; if the value in cell A10 is equal to 100, the expression evaluates to TRUE. Otherwise, the expression evaluates to FALSE. This argument can use any comparison calculation operator. value_if_true   Optional. The value that you want to be returned if the logical_test argument evaluates to TRUE. For example, if the value of this argument is the text string "Within budget" and the logical_test argument evaluates to TRUE, the IF function returns the text "Within budget." If logical_test evaluates to TRUE and the value_if_true argument is omitted; that is, there is only a comma following the logical_test argument, the IF f...

Learn the AND & IF formula step by step using this video

Here is a simple explanation of the various COUNT and IF formulas Here are some of the simple COUNT and IF formulas: COUNT - Counts number of cells with numbers in a range COUNTA - Counts number of non blank cells in a range COUNTBLANK - Counts number of blank cells in a range COUNTIF - Counts if a criteria is met in a range COUNTIFS - Counts if multiple criteria is met in a range SUM - Sum of a range SUMIF - Sum of a range if a single criteria is met SUMIFS - Sum of a range if multiple criteria are met Watch the video to understand the working of these formulas Welcome to Excel is Simple; A channel where we will help you will all your excel problems in the simplest possible way Subscribe to the channel by clicking http://www.youtube.com/user/excelissimple?sub_confirmation=1

Please excuse my dear aunt sally!!! See how the mathematical operators and their order can change your calculations as explained in the video.

A great way to understand the formula. Watch this video to know more

When working with lists and reports, you sometimes have repetitive data which you want to enter again and again. While you have the excel autocomplete function but if you have similar tellers at the beginning of the data, the autocomplete wont function properly. A very good shortcut for this would be the ctrl+down arrow. It is an easy means to speed through repetitive data entry within a column. Just one thing to remember, this shortcut does not work with numbered lists and here you need to type the entire number. Friends just try this tip while using your excel workbooks and do remember to share your tips that you thin are interesting and should be in the upcoming videos. Subscribe to the channel by clicking http://www.youtube.com/user/excelissimple?sub_confirmation=1