11Excel 4.(IF)IFとand 4.(IF)IF＋and

andは

AND(条件1,条件2,条件3、、、)のすべてが正しい時にTrue(正しい)を返す関数です

Excelの関数はANDと書いてもandと書いても構いません(大文字・小文字は受付けてくれる)

IFとandを組み合わせて使うと条件に合うものを

選んで結果を返します(出します)

式は入力してあります

and is a function that returns True (correct) when all AND (condition 1, condition 2, condition 3, ...) are correct.

Excel functions can be written as either AND or and.

When you combine IF and and, it selects the items that meet the conditions and returns the results.

The formula has already been entered.