始める無料で始める

Working with IF() functions

In this exercise, you will be getting a quick refresh on the IF function.

None of these examples have to do with loan amortization; these are just quick examples of how to use the IF() function. Your job is to enter the IF() formula, which fulfills the condition that is stated in words in column A.

So, if the statement was: "If the value in A3 is red, choose 'Stop,' otherwise choose 'Go.'" the IF() formula would be IF(A3 = "Red","Stop","Go").

この演習はコースの一部です

Google Sheetsで学ぶローン返済(アモチゼーション)

コースを見る

演習の手順

  • Test values are in column B.
  • Add the IF() formula which fulfills the condition in column D.
  • Make sure to refer to the test value in column B, don't enter the number.

実践的なインタラクティブ演習

理論を実践に変える、インタラクティブな演習のひとつをお試しください

演習を開始する