[算表] 簡易大於小於換算

作者: Abre (任愉悅)   2014-08-17 22:46:09
軟體:Excel
版本:2007
A1 B1
如果B1要設
if A1>100 , B1=A1/2
if A1<50 , B1=A1*2
if 50<=A1<=100 , B1=A1
Excel新人求解謝謝
(忽然被我爸問倒了)
作者: soyoso (我是耀宗)   2014-08-17 23:11:00
B1=A1*2^(A1<50)*0.5^(A1>100)

Links booklink

Contact Us: admin [ a t ] ucptt.com