[ 初めての方へ | 一覧(最新更新順) | 全文検索 | 過去ログ ]
『算数の計算問題』(ムーミンぱぱ)
数値 + 演算子 + 数値 なら
B1 =LEFT(ASC(A1),MIN(FIND({"+","-","×","÷"},ASC(A1)&"+-×÷"))-1) または B1 =-LOOKUP(1,-LEFT(A1,ROW($1:$20)))
C1 =REPLACE(ASC(A1),1,MIN(FIND({"+","-","×","÷"},ASC(A1)&"+-×÷")),) または C1 =-LOOKUP(1,-RIGHT(SUBSTITUTE(ASC(A1),"-","*"),ROW($1:$20)))
D1 =CHOOSE(SUM(ISNUMBER(FIND({"+","-","×","÷"},ASC(A1)))*{1,2,3,4}),B1+C1,B1-C1,B1*C1,B1/C1) D1 で計算。
複雑な四則演算なら
B1で名前定義
名前:計算 範囲: =EVALUATE(SUBSTITUTE(SUBSTITUTE(ASC(Sheet1!A1),"÷","/"),"×","*"))
B1 =計算 と入力 B1に結果 (GobGob) 2013/11/19(火) 07:44
過去の事例紹介! (稲葉) 2013/11/19(火) 08:31
(ムーミンぱぱ) 2013/11/20(水) 07:01
[ 一覧(最新更新順) ]
YukiWiki 1.6.7 Copyright (C) 2000,2001 by Hiroshi Yuki.
Modified by kazu.