当前位置：网站首页>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 ：
Insert picture description here
1、 Insert a formula into a cell Insert picture description here
Insert picture description here
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

边栏推荐

猜你喜欢

随机推荐