The right way to Use IF THEN Statements In Google Sheets

This information is about The right way to Use IF THEN Statements In Google Sheets. So learn this free information, The right way to Use IF THEN Statements In Google Sheets step-by-step. In case you have question associated to similar article chances are you’ll contact us.

The right way to Use IF THEN Statements In Google Sheets – Information

If/then sentences are sometimes thought-about troublesome. Nonetheless, they don’t seem to be troublesome to carry out in actuality. Additionally, when working with sure datasets or phrases in a spreadsheet, they are often extra helpful than you notice. This needs to be acquainted territory should you’ve labored with Microsoft Excel earlier than. Nonetheless, if you’re new to spreadsheets, the next data can be useful. Google Sheets is a free utility from Google that permits customers to alternate, generate and handle important information.

If you happen to’re new to spreadsheets, the If/Then statements might sound complicated at first. Capabilities are a technique of calculating information in your worksheet. There are just a few fundamentals to utilizing the predefined features in Google Sheets, whether or not it’s one thing as simple because the ‘SUM’ perform, which provides numbers for you, or one thing extra complicated. For a perform to carry out successfully, you could correctly set up the perform into its cells. For instance, begin the perform with the “=” signal, then the perform title, and eventually the argument.

Utilizing the IF perform

The IF perform can be utilized alone in a single logical take a look at, or you’ll be able to nest a number of IF statements in a single components for extra complicated assessments.

  • To get began, open your Google Sheets spreadsheet and kind =IF(take a look at, value_if_true, value_if_false) in a cell.
  • Substitute “take a look at” along with your logical take a look at, then change the “value_if_true” and “value_if_false” arguments with the operation or outcome that Google Sheets will present when the result’s TRUE or FALSE.
  • Within the instance proven beneath, an IF assertion is used to check the worth of cell B3. If cell B3 accommodates the letter B, the worth TRUE is returned in cell A3. On this case, it’s a textual content string containing the letter A.
  • If cell B3 doesn’t comprise the letter B, cell A3 returns the worth FALSE, which on this instance is a textual content string containing the letter C.
  • A easy IF assertion utilized in Google Sheets to check the worth of a cell, returning a TRUE outcome
  • Within the instance proven, cell B3 accommodates the letter B. The result’s TRUE, so the outcome TRUE (the letter A) is returned in A3.
  • The calculations additionally work effectively as a logical take a look at. Within the following instance, the IF components in cell A4 is testing whether or not cell B4 has a numeric worth equal to or larger than the quantity 10. If the result’s TRUE, it is going to return the #1. If false, it is going to return the quantity 2.

    An IF assertion being utilized in Google Sheets, returning a FALSE outcome. Within the instance, cell B4 has the worth 9. Which means the logical take a look at result’s FALSE, with the quantity 2 proven.

    nested IF statements

    If you wish to carry out an extended and extra complicated logical take a look at, you’ll be able to nest a number of IF statements in the identical components. To nest a number of IF statements collectively in a single components, sort easy =IF(first_test, value_if_true, IF(second_test, value_if_true, value_if_false)). Whereas this solely reveals a single nested IF assertion, you’ll be able to nest as many IF statements as you want.

    For instance, if cell B3 is the same as 4, the SE components in A3 will return 3. If cell B3 isn’t equal to 4, a second IF assertion is used to check whether or not cell B3 has a price lower than 10. returns the quantity 10. In any other case, it returns 0. This instance take a look at has its personal IF assertion nested as the primary argument “value_if_false”, requiring the primary take a look at to be FALSE earlier than the second take a look at is taken into account.

    A Google Sheets spreadsheet displaying nested IF statements multiplied with TRUE and FALSE outcomes

    The instance above reveals all three potential outcomes of this take a look at. With the primary logical take a look at (B3 equals 3) returning a TRUE outcome, the IF components in cell A3 returned the quantity 4. The second logical take a look at returned one other TRUE end in cell A4, with the worth of B4 lower than 10.

    The one FALSE result’s returned in cell A5, the place the results of each assessments (if B5 is the same as 3 or lower than 10) is FALSE, returning the outcome FALSE (a 0). You should utilize a nested IF assertion because the “value_if_true” argument in the identical method. To do that, sort =IF(first_test, IF(second_test, value_if_true, value_if_false), value_if_false).

    For instance, if cell B3 accommodates the quantity 3 and if cell C3 accommodates the quantity 4, return a 5. If B3 accommodates a 3, however C3 doesn’t comprise a 4, return a 0. If B3 doesn’t comprise a 3, return #1. A Google Sheets components containing nested IF statements with a number of TRUE and FALSE outcomes. The outcomes of this instance present that for the primary take a look at to be true, cell B3 should equal the quantity 3.

    From there, the “value_if_true” for the preliminary IF makes use of a second nested IF assertion to do a second take a look at (whether or not C3, C4, C5 or C6 comprise the quantity 4). This provides two potential “value_if_false” outcomes (a 0 or a 1). That is the case for cells A4 and A5. If you happen to don’t embody a FALSE argument for the primary take a look at, Google Sheets will return an computerized FALSE textual content worth to you. That is proven in cell A6 within the instance above.

    Remaining be aware

    I hope you just like the information The right way to Use IF THEN Statements In Google Sheets. In case you probably have any question regards this text chances are you’ll ask us. Additionally, please share your love by sharing this text with your folks.

    Leave a Comment