EXCEL工资表自动生成工资条里面添加一列生成不了数据。_百度知道
EXCEL工资表自动生成工资条里面添加一列生成不了数据。
以下函数代表什么意思？=IF(MOD(ROW(),2)=1,工资明细表!G$3,INDEX(工资明细表!$A:$BF,INT((ROW()+4)/2+1),COLUMN()))sheet3中引用sheet1数据 sheet1增加一列 再引用到sheet3 怎么引用不过去？
我有更好的答案
公式从“工资明细表”中提取数据到生成工资条的表。如果行奇数，则取“工资明细表”的标题行，否则取相应的记录(职工的工资数据）行。您先选定生成工资条的表，找到最左上角有公式的，选定，向右填充，再向下填充应该就好了。供参考，祝顺利。如果不行，发两个表的表头几行的截图就好了。
公式都是一样的啊！ 我还用文本差异比较过的 没什么差别。我直接插入列 表头 汉字是对的 但数据错位了一列 这是怎么回事？
您给个工资明细表的表头截图看下。否则不知从何说起。或者您看下最左上角的公式中有“工资明细表!G$3,”改3为2试下。
采纳率：79%
来自团队：
函数的意思是：如果行号是单数，则调用表1的工资表台头（第3行）；如果行号是双数号，则依次调入表1中的数据已建立好引用关系的两个表，数据源表结构发生变化，则调用表的调用关系可能与你预期的不一致，你需要重新调整，看你的公式，调整的方法也很简单，选最左上的一个单远格复制，再粘贴到所有区域就可以了
具体怎么操作？ 选择那个表中最左上单元格？ 粘贴到那个表区域上。
输公式的那张表最左上有公式调用的那个单元格，复制粘贴到本表其他需要输公式调用的区域
为您推荐：
其他类似问题
换一换
回答问题，赢新手礼包
个人、企业类
违法有害信息,请在下方选择后提交
色情、暴力
我们会通过消息、邮箱等方式尽快将举报结果通知您。在EXCERT中如何计算乘法。_百度知道
在EXCERT中如何计算乘法。
.在一个空单元格内输入1000，复制该单元格，选中A列数据区域，右击该区域，选择性粘贴：乘。2.操作方法同上：在一个空单元格中输入1.2，复制该单元格，选中B列数据区域，右击该区域，选择性粘贴：乘。
为您推荐：
其他类似问题
您可能关注的内容
换一换
回答问题，赢新手礼包
个人、企业类
违法有害信息,请在下方选择后提交
色情、暴力
我们会通过消息、邮箱等方式尽快将举报结果通知您。From Wikipedia, the free encyclopedia
This article needs additional citations for . Please help
by . Unsourced material may be challenged and removed. (September 2009) ()
Pink erasers
An eraser, (also called a
outside America, from the material first used) is an article of
that is used for removing writing from paper or skin. Erasers have a rubbery consistency and come in a variety of shapes, sizes and colours.
Some pencils have an eraser on one end. Less expensive erasers are made from
and synthetic -based gum, but more expensive or specialized erasers are , , or -like materials.
At first, erasers were made to erase mistake later, more abrasive
were introduced. The term is also used for things that remove writing from chalkboards and whiteboards. Ink erasers are denser, allowing them to erase pen marks.
Fragrant toy erasers for children
Before rubber erasers, tablets of wax were used to erase lead or charcoal marks from paper. Bits of rough stone such as
were used to remove small errors from parchment or papyrus documents written in ink. Crustless bread was used as a a -era () Tokyo student said: "Bread erasers were used in place of rubber erasers, and so they would give them to us with no restriction on amount. So we thought nothing of taking these and eating a firm part to at least slightly satisfy our hunger."
In 1770 English engineer
is reported to have developed the first widely marketed rubber eraser, for an inventions competition. Until that time the material was known as gum elastic or by its Native American name (via French) caoutchouc. Nairne sold natural rubber erasers for the high price of three shillings per half-inch cube. According to Nairne, he inadvertently picked up a piece of rubber instead of breadcrumbs, discovered rubber's erasing properties, and began selling rubber erasers. The invention was described by
on April 15, 1770, in a footnote: "I have seen a substance excellently adapted to the purpose of wiping from paper the mark of black-lead-pencil. ... It is sold by Mr. Nairne, Mathematical Instrument-Maker, opposite the Royal-Exchange." In 1770 the word rubber was in general use for any obj the word became attached to the new material sometime between 1770 and 1778.
However, raw rubber was perishable. In 1839
discovered the process of , a method that would
rubber, making it durable. Rubber erasers became common with the advent of vulcanization.
On March 30, 1858,
of , USA, received the first
for attaching an eraser to the end of a pencil. It was later invalidated because it was determined to be simply a composite of two devices rather than an entirely new product.
Erasers may be free-standing blocks (block and wedge eraser), or conical caps that can slip onto the end of a pencil (cap eraser). A
or click eraser is a device shaped like a pencil, but instead of being filled with , its barrel contains a retractable cylinder of eraser material (most commonly soft vinyl). Many, but not all, wooden pencils are made with attached erasers. Novelty erasers made in shapes intended to be amusing are often made of hard vinyl, which tends to smear heavy markings when used as an eraser.
Cap erasers.
Two kneaded erasers. A new eraser is on the left, and an older eraser on the right. The older eraser is darker due to the graphite and charcoal dust that has become incorporated into it.
An electric eraser tool with replacement eraser heads
Originally made from natural rubber, but now usually from cheaper , this type contains mineral fillers and an abrasive such as pumice with a
such as vegetable oil. They are relatively hard (in order to remain attached to the pencil) and frequently coloured pink.
The stylized word "Artgum" was first used in 1903 and trademarked in the USA in 1907. That type of eraser was originally made from oils such as
although may now be made from natural or synthetic rubber or vinyl compounds. It is very soft yet retains its shape and is not mechanically plastic, instead crumbling as it is used. It is especially suited to cleaning large areas without damaging paper. However, they are so soft as to be imprecise in use. The removed graphite is carried away in the crumbles, leaving the eraser clean, but resulting in a lot of eraser residue. This residue must then be brushed away with care, as the eraser particles are coated with the graphite and can make new marks. Art gum erasers are traditionally tan or brown, but some are blue.
Good quality plasticized
or other "plastic" erasers, originally trademarked Mylar in the mid-20th century, are softer, non-abrasive, and erase cleaner than standard rubber erasers. This was because the removed graphite did not remain on the eraser as much as rubber erasers, but was instead absorbed onto the discarded vinyl scraps. Being softer and non-abrasive, they were less likely to damage canvas or paper. Engineers favor this type of eraser for work on
due to their gentleness on paper with less smearing to surrounding areas. They often come in white and can be found in a variety of shapes. More recently, very low-cost erasers are manufactured from highly plasticized vinyl compounds and made in decorative shapes.
have a plastic consistency and are common to most artists' standard toolkit. They can be pulled into a point for erasing small areas and tight detail erasing, molded into a textured surface and used like a reverse stamp to give texture, or used in a "blotting" manner to lighten lines or shading without completely erasing them. They gradually lose their efficacy and resilience as they become infused with particles picked up from erasing and from their environment. They are not suited to erase large areas because of their tendency to deform under vigorous erasing.
Commonly sold in retail outlets with school supplies and home improvement products, this soft, malleable putty appears in many colours and under numerous brand names. Intended to adhere posters and prints to walls without damaging the underlying wall surface, poster putty works much the same as traditional kneaded erasers, but with a greater tack and in some circumstances, lifting strength. Poster putty does not erase so much as lighten by directly pulling particles of graphite, charcoal or pastel from a drawing. In this regard, poster putty does not smudge or damage work in the process. Repeatedly touching the putty to a drawing pulls ever more medium free, gradually lightening the work in a controlled fashion. Poster putty can be shaped into fine points or knife edges, making it ideal for detailed or small areas of work. It can be rolled across a surface to create visual textures. Poster putty loses its efficacy with use, becoming less tacky as the material grows polluted with debris and oils from the user's skin.
The electric eraser was invented in 1932 by
of Racine, Wisconsin, USA. It used a replaceable cylinder of eraser material held by a
driven on the axis of a motor. The speed of rotation allowed less pressure to be used, which minimized paper damage. Originally standard pencil-eraser rubber was used, later replaced by higher-performance vinyl.
went on to develop an entire line of hand-held rotary power tools.
A fibreglass eraser, a bundle of very fine glass fibres, can be used for erasing and other tasks requiring abrasion. Typically the eraser is a pen-shaped device with a replaceable insert with glass fibres, which wear down in use. The
in addition to removing pencil and pen markings, such erasers are used for cleaning traces on electronic circuit boards to facilitate soldering, removing rust, and many other applications. As an example of an unusual use, a fibreglass eraser was used for preparing an
embedded in a very hard and massive limestone.
or blackboard dusters are used to erase chalk markings on a . Chalk writing leaves light-coloured particles weakly adhering to a dark surface (e.g., white on black, or yellow on green); it can be rubbed off with a soft material, such as a rag. Erasers for chalkboards are made, with a block of plastic or wood, much larger than an eraser for pen or pencil, with a layer of felt on one side. The block is held in the hand and the felt rubbed against the writing, which it easily wipes off. Chalk dust is released, some of which sticks to the eraser until it is cleaned, usually by hitting it against a hard surface.
Various types of eraser, depending upon the board and the type of ink used, are used to erase a .
Dedicated erasers that are supplied with some
are intended only to erase the ink of the writing instrume sometimes this is done by making the ink bond more strongly to the material of an eraser than the surface it was applied to.
. dictionary.canadaspace.com 2018.
Teiy?kai (1926). K?bu daigakk? mukashibanashi (in Japanese). Tokyo: Teiy?kai. pp. 25–26.
See the footnote on page xv at the end of the preface to the following: Priestley, Joseph (1770). . London: J. John and J. Payne.
Joseph Priestley (1769). . J. D T. Cadell, successor to Mr. M and Johnson and Payne. p. 84.
R.B. Simpson (ed.), Rubber Basics, iSmithers Rapra Publishing, 2002,  , p.46 "Rubber"
Reg. No. 60496 & No. 435240, ERASERS OR ELASTIC COMPOSITIONS FOR ERASING MARKS FROM AND CLEANING DRAWINGS, TRACINGS, PICTURES []
US patent 2676160
Piedmont-Palladino, Susan (Summer 2005). "The Invisible History of Erasing". Blueprints (National Building Museum): 2.
Rendering with Pen and Ink (The Thames & Hudson Manuals), Robert W Gill. 1984, p191-193
Stecher, Rico (2008).
(PDF). Swiss J. Geosci. Birkh?user Verlag, Basel. : 2015.
U.S. Patent 3875105
Petroski, Henry (1989). The Pencil: A History of Design and Circumstance..
Wikimedia Commons has media related to .
by Rose Secrest
Pearlstein, E. J.; Cabelli, D.; King, A.; Indictor, N. (1982). . Journal of the American Institute for Conservation. 22 (1): 1–2. :.  .
: Hidden categories: