# Excel实战：全屋定制计算最大㎡

#### 貳·上公式

=MAX(SQRT(EVALUATE(C3)*EVALUATE(SUBSTITUTE(C3,"*","/",2))),SQRT(EVALUATE(C3)*EVALUATE(SUBSTITUTE(C3,"*","/",1))),EVALUATE(C3)/SQRT(EVALUATE(C3)*EVALUATE(SUBSTITUTE(C3,"*","/"))))/10^6

=EVALUATE(C3)/MIN(--MID(SUBSTITUTE(C3,"*",REPT(CHAR(32),100)),1,50),--MID(SUBSTITUTE(C3,"*",REPT(CHAR(32),100)),100,50),--MID(SUBSTITUTE(C3,"*",REPT(CHAR(32),100)),200,50))/10^6

#### 叁·思路一解析

a*b=√(a*b*c)*(a*b/c)

a*c=√(a*b*c)*(a/b*c)

b*c=(a*b*c)/a

=(a*b*c)/√a²

=(a*b*c)/√(a*b*c)*(a/b/c)

（a*b*c）很简单，公式EVALUATE(C3)就搞定。

EVALUATE(C3)*EVALUATE(SUBSTITUTE(C3,"*","/",2))

（a/b/c）同理。SQRT函数取整数平方根。

=MAX(SQRT(EVALUATE(C3)*EVALUATE(SUBSTITUTE(C3,"*","/",2))),SQRT(EVALUATE(C3)*EVALUATE(SUBSTITUTE(C3,"*","/",1))),EVALUATE(C3)/SQRT(EVALUATE(C3)*EVALUATE(SUBSTITUTE(C3,"*","/"))))/10^6

#### 肆·思路二解析

=SUBSTITUTE(C3,"*",REPT(CHAR(32),100)

--MID(SUBSTITUTE(C3,"*",REPT(CHAR(32),100)),1,50)

MID函数前加两个负号，去除多余空格，转化为数值格式。

=EVALUATE(C3)/MIN(--MID(SUBSTITUTE(C3,"*",REPT(CHAR(32),100)),1,50),--MID(SUBSTITUTE(C3,"*",REPT(CHAR(32),100)),100,50),--MID(SUBSTITUTE(C3,"*",REPT(CHAR(32),100)),200,50))/10^6