if | Excel

Warning: include_once(/home/sites/heteml/users/m/o/r/moriya-h5/web/confrage/bin/top_msg.php): failed to open stream: No such file or directory in /home/users/2/moriya-h5/web/confrage/excel/function/if/if.html on line 22

Warning: include_once(): Failed opening '/home/sites/heteml/users/m/o/r/moriya-h5/web/confrage/bin/top_msg.php' for inclusion (include_path='.:/usr/local/php/5.6/lib/php') in /home/users/2/moriya-h5/web/confrage/excel/function/if/if.html on line 22

Warning: include_once(/home/sites/heteml/users/m/o/r/moriya-h5/web/confrage/bin/menu.php): failed to open stream: No such file or directory in /home/users/2/moriya-h5/web/confrage/excel/function/if/if.html on line 29

Warning: include_once(): Failed opening '/home/sites/heteml/users/m/o/r/moriya-h5/web/confrage/bin/menu.php' for inclusion (include_path='.:/usr/local/php/5.6/lib/php') in /home/users/2/moriya-h5/web/confrage/excel/function/if/if.html on line 29

トップページ > Excel > if

初版2006/08/02：最終更新日2006/08/02

ifは、第一引数で式を指定し、その式がtrueなら第二引数を返します。
falseであれば第三引数を返す関数です。
下図を見てください。

第一引数で、 D3=D4 としています。
D3セルは「3」で、D4セルは「4」のためこの式はfalseとなります。
よって第三引数である-999が返ってきます。
ちなみにtrueの場合は第二引数の0が返ってきます。

HOME

Warning: include_once(/home/sites/heteml/users/m/o/r/moriya-h5/web/confrage/bin/side_bar.php): failed to open stream: No such file or directory in /home/users/2/moriya-h5/web/confrage/excel/function/if/if.html on line 77

Warning: include_once(): Failed opening '/home/sites/heteml/users/m/o/r/moriya-h5/web/confrage/bin/side_bar.php' for inclusion (include_path='.:/usr/local/php/5.6/lib/php') in /home/users/2/moriya-h5/web/confrage/excel/function/if/if.html on line 77