当前位置:网站首页>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
边栏推荐
- Matplotlib tutorial 05 --- operating images
- Detailed explanation of gzip and gunzip decompression parameters
- Day (3) of picking up matlab
- Website pressure measurement tools Apache AB, webbench, Apache jemeter
- 第九天 static 抽象类 接口
- 【现代电子装联期末复习要点】
- [pyGame games] how did angry birds, a mobile game that became popular all over the world 10 years ago, dominate the list? Classic return
- Win11/10家庭版禁用Edge的inprivate浏览功能
- There is a problem with the light switch from 1 to 100
- Ice -- source code analysis
猜你喜欢

Day 9 static abstract class interface

第九天 static 抽象类 接口

Cloud migration practice in the financial industry Ping An financial cloud integrates hypermotion cloud migration solution to provide migration services for customers in the financial industry

Day (7) of picking up matlab

漫画:什么是IaaS、PaaS、SaaS?

Cloudy data flow? Disaster recovery on cloud? Last value content sharing years ago

TIA botu - basic operation

捡起MATLAB的第(7)天

Jour (9) de ramassage de MATLAB

Summary according to classification in sail software
随机推荐
MySQL - execution process of MySQL query statement
Construction of esp32 compilation environment
捡起MATLAB的第(2)天
ESP32_Arduino
Research and Practice on business system migration of a government cloud project
Master vscode remote GDB debugging
MySQL的btree索引和hash索引区别
The first line and the last two lines are frozen when paging
Gartner 发布新兴技术研究:深入洞悉元宇宙
VMware Workstation cannot connect to the virtual machine. The system cannot find the specified file
The biggest winner is China Telecom. Why do people dislike China Mobile and China Unicom?
力扣-746.使用最小花费爬楼梯
Countdown 1 day ~ 2022 online conference of cloud disaster tolerance products is about to begin
Hyperbdr cloud disaster recovery v3 Version 2.1 release supports more cloud platforms and adds monitoring and alarm functions
Database dbvisualizer Pro reported file error, resulting in data connection failure
What is the experience of using prophet, an open source research tool?
How important is the operation and maintenance process? I heard it can save 2 million a year?
Esxi encapsulated network card driver
【现代电子装联期末复习要点】
How magical is the unsafe class used by all major frameworks?