电子表格小写变大写公式答:小写变大写公式如下:1.=substitute(substitute(if(a1>-0.5%,,"负")&text(int(fixed(abs(a1))),"2.[dbnum2]g/通用格式元;;")&text(right(fixed(a1),2),"[dbnum2]0角0分;;"&if(abs(a1)>1%,"整",)),"零角",if(abs(a1)<1,,"零")),"零分","整")电子表格:又称电子数据...
电子表格 如果是周六或周日,主任是李三,否则是张三,怎么写答:如果电子表格的日期是2014-6-17的这种格式在A1的话,那么在B1输入=IF(WEEKDAY(A1,2)>=6,"李三","张三")。如果日期格式是周六这种格式的话=IF(A1="周六","李三",IF(A1="周日","李三","张三"))