题目
如a列是1-33任意数组成的一列,想在b列用公式将a列中除1—9除外,将其余的2位数的数全部替换成a—x的字母.如10替换为a,11替换为b.
提问时间:2021-04-02
答案
楼上的公式可以,但是要做就帮人做全了,人家要再B列转化,你给人家一个J列的.
搂主在B列第一格里填上这个,然后向下填充就好了.
=IF(A1<10,A1,CHOOSE(A1-9,"a","b","c","d","e","f","g","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x"))
搂主在B列第一格里填上这个,然后向下填充就好了.
=IF(A1<10,A1,CHOOSE(A1-9,"a","b","c","d","e","f","g","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x"))
举一反三
已知函数f(x)=x,g(x)=alnx,a∈R.若曲线y=f(x)与曲线y=g(x)相交,且在交点处有相同的切线,求a的值和该切线方程.
我想写一篇关于奥巴马的演讲的文章,写哪一篇好呢?为什么好
奥巴马演讲不用看稿子.为什么中国领导演讲要看?
想找英语初三上学期的首字母填空练习……
英语翻译
最新试题
热门考点
- 1数学题;用999文买1000个梨和苹果,梨11文9个,苹果4文6个,请问梨和苹果各买几个
- 2好像是让你写什么《夸父逐日》的.
- 3传送带1m/s水平匀速运动斗沙20kg/s向带上装沙子为保持带速率不变驱动带的电动机功率应增加多少
- 4一道高中物理题目,求解.
- 5“初一我学到了_______”作文.
- 6预习导航
- 7五十七乘以七等于几呢?
- 8There are many trees near the road ,____ ______?(改为反意疑问句) 什么是反意疑问句
- 9good,you,is,will,when,stress,the,gone,feel连词成句
- 101L多大浓度的氨水可以溶解0.1mol的AgCl?(如果是溴化银、碘化银呢)