{"blog_url":"https://cubita.hatenadiary.org/","categories":["Excel"],"height":"190","author_name":"cubita","description":"Excel\uff08\u306b\u9650\u3089\u306a\u3044\u3068\u601d\u3044\u307e\u3059\u304c\uff09\u3067if\u3092\u306f\u3052\u3057\u304f\u30cd\u30b9\u30c8\u3055\u305b\u308b\u3068\u982d\u304c\u6df7\u4e71\u3057\u3066\u304d\u307e\u3059\u3088\u306d\u3002\u5b9f\u306fExcel\u3067\u306f\u3001\u300c\uff0a\u300d\u300c\uff0b\u300d\u306e\u6f14\u7b97\u5b50\u3092\u7528\u3044\u3066\u3001\u30cd\u30b9\u30c8\u3055\u305b\u305a\u306bif\u6587\u3067\u8907\u6570\u6761\u4ef6\u3092\u5224\u5225\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002 \u610f\u5916\u3068\u8ab0\u3082\u4f7f\u3063\u3066\u3044\u306a\u3044\u3088\u3046\u306a\u306e\u3067\u3001\u3053\u3053\u306b\u30e1\u30e2\u3063\u3066\u304a\u304d\u307e\u3059\u3002\u307e\u305a\u3001Excel\u3092\u958b\u3044\u3066\u304f\u3060\u3055\u3044\u306d\u3002 \u307e\u305a\u6e96\u5099 A B C 1 \u65e5\u8a18 \u65e5\u8a18 \u53cb\u9054 2 \u30d6\u30c3\u30af\u30de\u30fc\u30af \u30d6\u30c3\u30af\u30de\u30fc\u30af \u306a\u308c\u5408\u3044 3 \u30a2\u30f3\u30c6\u30ca \u3042\u3057\u3042\u3068 \u3053\u3093\u306a\u611f\u3058\u3067\u5165\u308c\u307e\u3059\u3002 \u3042\u307e\u308a\u77e5\u3089\u308c\u3066\u3044\u306a\u3044if\u306e\u4f7f\u3044\u65b9 \u3067\u3001\u9069\u5f53\u306a\u30bb\u30eb\u306b\u3001 =IF((A1=\"\u65e5\u8a18\")*(A2=\"\u30d6\u30c3\u30af\u30de\u30fc\u30af\"),\"\u306f\u3066\u306a\",\"mixi\") \u3042\u308b\u3044\u306f =IF((B1=\"\u65e5\u8a18\"\u2026","provider_url":"https://hatena.blog","type":"rich","provider_name":"Hatena Blog","published":"2007-06-18 00:33:53","version":"1.0","blog_title":"think ambivalent","width":"100%","title":"IF\u95a2\u6570\u3067\u30cd\u30b9\u30c8\uff08\u5165\u308c\u5b50\uff09\u3057\u306a\u3044\u3067\u8907\u6570\u6761\u4ef6\u3092\u6271\u3046\u65b9\u6cd5","image_url":null,"url":"https://cubita.hatenadiary.org/entry/20070618/1182180833","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fcubita.hatenadiary.org%2Fentry%2F20070618%2F1182180833\" title=\"IF\u95a2\u6570\u3067\u30cd\u30b9\u30c8\uff08\u5165\u308c\u5b50\uff09\u3057\u306a\u3044\u3067\u8907\u6570\u6761\u4ef6\u3092\u6271\u3046\u65b9\u6cd5 - think ambivalent\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","author_url":"https://blog.hatena.ne.jp/cubita/"}