1. PTT
  2. ask

[请问] excel函数选择

楼主: KomeijiYuki (古明地雪)   2017-09-26 20:35:36
各位好
想请问一下像下图所示
https://puu.sh/xJhNd/8a25489127.png
若指定范围内储存格符合条件便显示结果
(反之则无)
如 A1:C1有1个数字便显示1
A2:C2有2个数字一样显示1
A4:C4没有数字便不显示
应该用哪个函数呢?
作者: firstbankMA (First Bank MA)   2017-09-26 20:40:00
=IF(SUM(A1:C1)>=1,1,0)=IF(SUM(A1:C1)>=1,1," ")
继续阅读
[请问] 大安路上的无名早餐店(抓饼蛋饼)firstbankMA[请问] 微信怎么关掉视讯、语音通话?butachan[请问] TG设成不出现在有我电话的联络人名单里？LAHSAPKUI[请问] 垃圾食品会损害人类嗅觉吗？changshingo[请问] 想问一首清朝诗gameplus[请问] 2016 ppt 在2010版播放jack86805[请问] 现在的手电筒很容易坏吗？netjedi[请问] 清洗洗衣机内槽ads025[请问] 玩游戏胃痛的意思qqhsu[请问] 模特儿dicky4206

Links booklink

Contact Us: admin [ a t ] ucptt.com