Basic Excel Simple formulas

Excel Some Useful Shortcuts Excel Some Useful Shortcuts Shortcut key Action Menu equivalent comments Alt or F10 Menu Go to Menu bar Alt+’ Format Style dialog box Format the Style Alt+= AutoSum Sum Formaula Showing in Cell Alt+Down arrow Display AutoComplete list Displaying Auto Complete Data List Alt+F1 Insert Chart Insert the Chart Alt+F11 Visual Basic Editor Tools, Macro, Visual Basic Editor Alt+F2 Save As Save File to Save As Alt+F4 Exit File Exit Alt+F8 Macro dialog box Macro dialog box Tools Alt+Shift+F1 New worksheet Insert New Worksheet Alt+Shift+F2 Save Save the File Ctrl + Shift + L Filter Filter the Row Ctrl W Close Close the Open File Ctrl+- Delete Delete the Rows, Columns and Cells Right or Down Depends on selection Ctrl+! Format cells dialog box Font Tab Open in F...

​How to Use IF Function Formula in Excel Excel IF function Formula IF function Formula is one of the Excel's logical function Formula that evaluates a certain condition and returns the value you specify if the condition is TRUE, and another value if the condition is FALSE. The syntax for Excel IF Function Formula is as follows: IF(logical_test, [value_if_true], [value_if_false]) As you see, the IF function has 3 arguments, but only the first one is obligatory, the other two are optional. Some List of Example : ​Example : 1 * logical_test  - a value or logical expression that can be either TRUE or FALSE. Required.In this argument, you can specify a text value, date, number, or any comparison operator. For example, your logical test can be expressed as or A1="Yes", A1<200, A1=5000 or A1>500. * value_if_true  - the value to return when the logical test evaluates to TRUE, i.e. if the condition is met. Optional.For example, the following...