当前位置:网站首页>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
边栏推荐
- Day (9) of picking up matlab
- The first line and the last two lines are frozen when paging
- Phpstudy V8, a commonly used software for station construction 1 graphic installation tutorial (Windows version) super detailed
- 捡起MATLAB的第(9)天
- There is a problem with the light switch from 1 to 100
- homwbrew安装、常用命令以及安装路径
- Start Oracle service on Linux
- Ali developed three sides, and the interviewer's set of combined punches made me confused on the spot
- Day (5) of picking up matlab
- Introduction notes to PHP zero Foundation (13): array related functions
猜你喜欢
GRBL学习(一)
捡起MATLAB的第(9)天
homwbrew安装、常用命令以及安装路径
Nanny Anaconda installation tutorial
Summary according to classification in sail software
Cartoon: what are IAAs, PAAS, SaaS?
Gartner predicts that the scale of cloud migration will increase significantly; What are the advantages of cloud migration?
Nacos detailed explanation, something
MySQL - execution process of MySQL query statement
【现代电子装联期末复习要点】
随机推荐
Matplotlib tutorial 05 --- operating images
Simple usage of dlopen / dlsym / dlclose
最详细的背包问题!!!
MySQL - MySQL查询语句的执行过程
Change the icon size of PLSQL toolbar
451. 根据字符出现频率排序
Cloudy data flow? Disaster recovery on cloud? Last value content sharing years ago
Day (7) of picking up matlab
Algorithem_ ReverseLinkedList
安装Redis并部署Redis高可用集群
ESP32_Arduino
捡起MATLAB的第(9)天
ESP32编译环境的搭建
Nacos detailed explanation, something
05 Lua control structure
The biggest winner is China Telecom. Why do people dislike China Mobile and China Unicom?
捡起MATLAB的第(10)天
Read the meaning of serial port and various level signals
【Pygame小游戏】10年前风靡全球的手游《愤怒的小鸟》,是如何霸榜的?经典回归......
linux上啟動oracle服務