> ## Documentation Index
> Fetch the complete documentation index at: https://help.dingtalk.io/llms.txt
> Use this file to discover all available pages before exploring further.

# 公式案例

> 本页面提供了多种函数公式的案例文档，涵盖从获取上级部门名称到计算折扣后价格等多个应用场景。每个案例都列出了所涉及的具体函数，点击案例名称可跳转至详细配置页面。

**本篇主要介绍函数公式现有的案例文档，点击案例名称即可跳转详细配置页面，如下：**

| **案例链接**                                                                           | **涉及函数**                                 |
| ---------------------------------------------------------------------------------- | ---------------------------------------- |
| [如何获取上级部门名称](https://www.yuque.com/yida/subject/thmohn)                            | DEPTNAME                                 |
| [如何限制年假请假天数](https://www.yuque.com/yida/subject/tzxrgt)                            | DAYS                                     |
| [如何根据成绩判断等级](https://www.yuque.com/yida/subject/xm7a3y)                            | IF                                       |
| [生成固定长度的随机字符串](https://www.yuque.com/yida/subject/tnmemu)                          | UUID                                     |
| [根据身份证号自动计算生肖](https://docs.aliwork.com/docs/yida_support/yida_subject/_5/qtyzwl)  | IF、EQ、MOD、LEN、VALUE                      |
| [根据身份证号自动计算性别](https://docs.aliwork.com/docs/yida_support/yida_subject/_5/mo5sop)  | IF、EQ、MID、OR                             |
| [根据身份证号自动计算省份](https://docs.aliwork.com/docs/yida_support/yida_subject/_5/wum47y)  | IF、EQ、MID、LEN、VALUE                      |
| [根据身份证号获取出生日期](https://docs.aliwork.com/docs/yida_support/yida_subject/_5/pgy02a)  | IF、EQ、MID、CONCATENATE、LEN                |
| [根据身份证号自动计算星座](https://docs.aliwork.com/docs/yida_support/yida_subject/_5/axb9sx)  | IF、EQ、MID、LEN、VALUE、GE、AND、LE            |
| [根据身份证号自动计算年龄](https://docs.aliwork.com/docs/yida_support/yida_subject/_5/fm0i23)  | IF、EQ、LEN、VALUE、TODAY、TEXT、RIGHT、LEFT    |
| [如何将手机号部分数字隐藏](https://docs.aliwork.com/docs/yida_support/yida_subject/_5/kyqu7a)  | REPLACE                                  |
| [如何随机抽取题目](https://www.yuque.com/yida/subject/rz8bwk)                              | 代码实现                                     |
| [如何将文本转换为日期格式](https://www.yuque.com/yida/subject/vs68sn)                          | MID、DATE、TIMESTAMP                       |
| [日期自动加十天](https://www.yuque.com/yida/subject/qp7er3)                               | DATEDELTA、DATE、IF、ISEMPTY                |
| [最新版个税计算器](https://www.yuque.com/yida/subject/nsg238)                              | IF、AND、EQ、LE 、 GT                        |
| [多评委打分如何计算平均分](https://www.yuque.com/yida/subject/wcgzkk)                          | MAX、VALUE、ARRAYGET、SPLIT、MIN、CONCATENATE |
| [如何修改标题大小](https://www.yuque.com/yida/subject/enmapm)                              | 代码实现                                     |
| [如何设置百分比](https://www.yuque.com/yida/subject/ggrd75)                               | TEXT                                     |
| [根据 QQ 号自动生成邮箱](https://docs.aliwork.com/docs/yida_support/yida_subject/_5/mmxycd) | IF、ISEMPTY、CONCATENATE                   |
| [如何设置小数位数](https://docs.aliwork.com/docs/yida_support/yida_subject/_5/gqmff3)      | ROUND                                    |
| [如何将数字转换为大写](https://www.yuque.com/yida/subject/olahot)                            | RMBFORMAT、INT                            |
| [字符串中的数字应用](https://www.yuque.com/yida/subject/sopweh)                             | EQ、VALUE                                 |
| [如何计算工龄](https://www.yuque.com/yida/subject/vwpw2e)                                | INT、DAYS、DATE、IF、OR、ISEMPTY              |
| [每人每天只能提交一条数据](https://www.yuque.com/yida/subject/htkems)                          | USER、SYSTIME、TIMESTAMP、TEXT、DATE、EXIST   |
| [如何计算折扣后价格](https://www.yuque.com/yida/subject/oa3y8p)                             | SUM、IF、LT                                |
| [如何将发票金额拆分](https://www.yuque.com/yida/subject/oa65nn)                             | IF、GT、AND、LE、RIGHT、LEFT、INT              |
| [如何生成固定格式的流水号](https://www.yuque.com/yida/subject/nuprrb)                          | COUNT                                    |
| [如何获取主管](https://www.yuque.com/yida/subject/uw2z03)                                | DEPTNAME                                 |
| [如何通过公式获取日期区间的结束时间](https://www.yuque.com/yida/subject/oxwz0e)                     | MID、SEARCH                               |
| [宜搭常见提示的说明](https://www.yuque.com/yida/subject/zbdfeb#N3rIw)                       | //                                       |