Tip #5

An IF formula is one of the most useful terms in Excel. It’s a conditional formula that allows you to calculate one way if something is true and another if something is false.


[value_if_true], [value_if_false])

The condition is the value that you want to test.  The value_if_true is the value that will be returned if the condition is TRUE. The value_if_false is the value that will be returned if the condition is FALSE.

For example:

Excel 5

If we assume those are student’s grades on a paper and we want to know which students have passed and which have failed without having to go line by line, we would use this formula and copy down:

=IF(A1>=60, “PASS”, “FAIL”)

That is to say, if the value in cell A1 is greater than or equal to 60, then return “Pass”, if not then return “Fail”

Excel 6

For more advanced conditional statements, you can nest multiple IF Formulas or use IFERROR to determine what you want Excel to return in the event that it evaluates to an error!


If you would like to learn more about this or any Microsoft Dynamics product, please contact Complete Software by calling 410-740-1090 or by emailing support@completesoftware.net!

Based out of Columbia, Maryland, Complete Software Solutions (CSS) is proud to be a Microsoft Partner and Value Added Reseller (VAR) for Microsoft Dynamics GP and Microsoft Dynamics SL as well as a unique software developer providing solutions for businesses and non-profit organizations throughout the country. We offer a variety of services including Microsoft Dynamics consulting, system evaluation, business process analysis, system design, customizations, Enterprise Resource Planning (ERP) implementations and system upgrades.