当前位置:网站首页>Use if else to judge in sail software - use the title condition to judge
Use if else to judge in sail software - use the title condition to judge
2022-04-23 16:26:00 【Huang ha ha~】
My requirement here is to judge in the title ( Beginning of the year , Mid - ), These two to judge , Set the title in the normal report .
effect :
1、 Insert a formula into a cell
The formula is as follows :if(versionTypeBefore=1&&versionType=1,“ Investment and capital plan of fixed investment projects “+ p l a n Y e a r B e f o r e + " ( year first ) − " + planYearBefore+"( Beginning of the year )-"+ planYearBefore+"( year first )−"+planYear+”( Beginning of the year )”+“ Adjustment summary ”,if(versionTypeBefore=1&&versionType=3,“ Investment and capital plan of fixed investment projects “+ p l a n Y e a r B e f o r e + " ( year first ) − " + planYearBefore+"( Beginning of the year )-"+ planYearBefore+"( year first )−"+planYear+”( Mid - )”+“ Adjustment summary ”,if(versionTypeBefore=3&&versionType=1,“ Investment and capital plan of fixed investment projects “+ p l a n Y e a r B e f o r e + " ( in period ) − " + planYearBefore+"( Mid - )-"+ planYearBefore+"( in period )−"+planYear+”( Beginning of the year )”+“ Adjustment summary ”,if(versionTypeBefore=3&&versionType=3,“ Investment and capital plan of fixed investment projects “+ p l a n Y e a r B e f o r e + " ( in period ) − " + planYearBefore+"( Mid - )-"+ planYearBefore+"( in period )−"+planYear+”( Mid - )”+“ Adjustment summary ”,))))
The point is to add a comma at the end , Because the comma is else It means , So you must add... At the end else, otherwise , The one in front if Judgment cannot be performed . This is the pit I encountered , In fact, that is if-else Is inseparable .
版权声明
本文为[Huang ha ha~]所创,转载请带上原文链接,感谢
https://yzsam.com/2022/04/202204231403370959.html
边栏推荐
猜你喜欢
Install redis and deploy redis high availability cluster
G008-hwy-cc-estor-04 Huawei Dorado V6 storage simulator configuration
C language self compiled string processing function - string segmentation, string filling, etc
Intersection, union and difference sets of spark operators
Coalesce and repartition of spark operators
You need to know about cloud disaster recovery
Read the meaning of serial port and various level signals
Cartoon: what are IAAs, PAAS, SaaS?
【现代电子装联期末复习要点】
Interview question 17.10 Main elements
随机推荐
Unity shader learning
Cloudy data flow? Disaster recovery on cloud? Last value content sharing years ago
Day (4) of picking up matlab
Construction of esp32 compilation environment
The system research problem that has plagued for many years has automatic collection tools, which are open source and free
vim编辑器的实时操作
Intersection, union and difference sets of spark operators
How to quickly batch create text documents?
捡起MATLAB的第(9)天
Start Oracle service on Linux
Change the icon size of PLSQL toolbar
What is the experience of using prophet, an open source research tool?
Day (7) of picking up matlab
安装Redis并部署Redis高可用集群
第十天 异常机制
ESXi封装网卡驱动
MySQL - execution process of MySQL query statement
100 deep learning cases | day 41 - convolutional neural network (CNN): urbansound 8K audio classification (speech recognition)
Gartner 发布新兴技术研究:深入洞悉元宇宙
PHP 零基础入门笔记(13):数组相关函数