如果交通信号灯产生0值,如何使它显示为零值空白?现在,它返回此值:#VALUE!. (使用下面的公式)
If the stoplight produces a 0 value how do you get it to appear blank for a zero value? Right now it returns this: #VALUE!. (using the formula below)
使用以下公式,如何获取公式以产生两位数的信号灯:我正在寻找使其在数字13上生成黑色并在数字15上生成白色的方法?
Using the formula below how do you get the formula to produce a stoplight for a double digit value: i was looking to get it to generate black on the number 13 and white on the number 15?
=""< DIV样式='font-weight:bold; font-size:45px; text-align:center;颜色:& choose(RIGHT(LEFT(CASES,2),1)",绿色",红色",黄色",橙色",蓝色",紫色", 灰色",黑色",白色")和;"/"/DIV">
="<DIV style='font-weight:bold; font-size:45px; text-align:center; color:"&CHOOSE(RIGHT(LEFT(CASES,2),1),"green","red","yellow","orange","blue","purple","grey","black","white")&";'>•</DIV>"
推荐答案其他, 要使它对于零值显示为空白,可以使用IF函数. 要在数字13上生成黑色,在数字15上生成白色,可以在第三位置设置黑色,在第五位置设置白色.
Hi else, To get it to appear blank for a zero value, you can use IF Function. To generate black on the number 13 and white on the number 15, you can set black at the third position and white at fifth position.
="<DIV style='font-weight:bold; font-size:45px; text-align:center; color:"&IF(CASES=0,"white",CHOOSE(RIGHT(LEFT(CASES,2),1),"green","red","black","orange","white","purple","grey","yellow","blue"))&";'>•</DIV>"
参考:
Reference:
选择功能:
support.office/en -us/article/CHOOSE-function-e4b61fbc-40a4-4fe2-8b9c-c5e7a51fdbbe
左移功能:
support.office/en -us/article/LEFT-function-913824b4-fc42-4c8c-9229-0eaa57dcdf49
IF函数:
support.office/en -us/article/IF-function-7025be14-5665-43d0-af20-8293d1fe9d3a
RIGHT功能:
support.office/en -us/article/RIGHT-function-112699e2-fe7e-4cbf-8d1e-0e8db3884f26
最好的问候,
Lisa Chen
Lisa Chen
更多推荐
交通灯(状态灯问题)
发布评论