天气预报15天查询> 科技> Excel表格里FIXED函数怎么用

Excel表格里FIXED函数怎么用

更新时间: 2021-01-31 08:44:42     

1、在EXCEL表格中,输入一些参数出来。用于学习FIXED函数。

2、点击单元格,点击公式菜单,点击文本函数的FIXED函数。

3、数据选择AI,小数位数,看你自已要求,点击确定。

4、这样就可以使用FIXED函数实现取数值的两位置位。

关键词: excel 表格 fixed 函数 怎么

如有意见、反馈、侵权或投诉等情况,请联系:

电话:
邮箱:

我们将会在48小时内给与处理!

版权所有 Copyright ? 2009-2020 tianqiyubao3.com

页面:/news/view-2424754/ | 耗时:0.2382 s | 内存:1.89 MB | 查询:6 | 缓存读取:4 写入:2 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=2424754 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=2424754 LIMIT 0,1
SELECT * FROM tbl_categories where CategoryID=90015 LIMIT 0,1
select * from tbl_Articles_sphinx where id=2424754 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(454932,2839256,816537,1744503,489113,3203821,1923299,1130315,518469,820119,1018834,3128864,793027,2130159,1676959,951810,1142034,3244330,674801,1793893,3191319,925048,424460,1316846,3119572,3191784,860541,1020775,1395216,1489738) ORDER BY field (ArticleID,454932,2839256,816537,1744503,489113,3203821,1923299,1130315,518469,820119,1018834,3128864,793027,2130159,1676959,951810,1142034,3244330,674801,1793893,3191319,925048,424460,1316846,3119572,3191784,860541,1020775,1395216,1489738)
SELECT ArticleID,Title FROM tbl_Articles where CategoryID=90015 ORDER BY ArticleID DESC LIMIT 20