excel乘法怎么操作
今天跟大家分享一下带有单位的Excel表格如何计算乘积
![](/wp-content/uploads/images/2023/04/21/567f04631c934bec8343d0724272156e_bydqjbwtyej.gif)
如下图,是某便利店进货单,产品单价即数量均带有单位,现在想要快速得出各商品总价即各产品单价乘以产品数量。
![](/wp-content/uploads/images/2023/04/21/a0b663e9184c4144a26f42c29f56948f_bt4llxtzojf.jpg)
在D2单元格输入1*100,即白菜单价乘以白菜数量
![](/wp-content/uploads/images/2023/04/21/f7370e43dec44a84a8b5bfc609257c90_uz15c5ev4m3.jpg)
在D3单元格输入60*10,即牛奶单价乘以牛奶数量。
![](/wp-content/uploads/images/2023/04/21/77cbb374abc148f9a7cc086268212061_0hoc4oq2mqy.jpg)
单击D4单元格,然后按下Ctrl+E(快速填充快捷,低版本Excel可能无此功能)低版本Excel需要手动录入。
![](/wp-content/uploads/images/2023/04/21/02f3a8597f6d4e74a4d7a7daf8fb9c29_yd00gvielfg.jpg)
点击下图选项(Excel工具箱,百度进入其官网即可安装,本文不作详细叙述)
![](/wp-content/uploads/images/2023/04/21/794387126a524c36a2aa80cbb7430a5a_wa04asgddpk.jpg)
点击【数值】选项
![](/wp-content/uploads/images/2023/04/21/281bb802ae774c0da5dbb4a98fa2af80_jlci2cm4ump.jpg)
选择【公式-文本转换】
![](/wp-content/uploads/images/2023/04/21/2319711c4d7f4405b7bb3e934cc287a4_5i1tdtvpiye.png)
在【选区】中输入D2:D10单元格区域
![](/wp-content/uploads/images/2023/04/21/81c9776ebffe44d8ba5ba7f0864d602d_lnb1thtrwhd.jpg)
勾选【文本转公式】,然后点击【确定】即可完成各产品总价计算
![](/wp-content/uploads/images/2023/04/21/80736e878bdd44c3ae1f717a225e640d_xnxbjey0qex.jpg)
即可完成各产品总价计算且完成结果如下图
![](/wp-content/uploads/images/2023/04/21/9d9a174193d840939d48711e8048c55b_wcdkxn22c3l.jpg)