如何在Excel进行除法

下载PDF文件
下载PDF文件

微软的Excel是一种电子表格程序，它能让你组织和存储数据。它的其中一项主要功能是根据你的需要提供能够进行加减乘除的数学函数。阅读本文了解如何在Excel中进行处罚。

方法 1
方法 1 的 4:

方法 在Excel中输入数据

下载PDF文件
  1. 1
    在你的计算机上打开微软Excel程序。
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/bd\/Divide-in-Excel-Step-2.jpg\/v4-460px-Divide-in-Excel-Step-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bd\/Divide-in-Excel-Step-2.jpg\/v4-728px-Divide-in-Excel-Step-2.jpg","smallWidth":460,"smallHeight":199,"bigWidth":728,"bigHeight":315,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/b6\/Divide-in-Excel-Step-3.jpg\/v4-460px-Divide-in-Excel-Step-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b6\/Divide-in-Excel-Step-3.jpg\/v4-728px-Divide-in-Excel-Step-3.jpg","smallWidth":460,"smallHeight":285,"bigWidth":728,"bigHeight":451,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    在添加数据时应定期地保存你的电子表格。
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/6b\/Divide-in-Excel-Step-4.jpg\/v4-460px-Divide-in-Excel-Step-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6b\/Divide-in-Excel-Step-4.jpg\/v4-728px-Divide-in-Excel-Step-4.jpg","smallWidth":460,"smallHeight":285,"bigWidth":728,"bigHeight":451,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    广告
方法 2
方法 2 的 4:

方法 格式化单元格

下载PDF文件
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/de\/Divide-in-Excel-Step-5.jpg\/v4-460px-Divide-in-Excel-Step-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/de\/Divide-in-Excel-Step-5.jpg\/v4-728px-Divide-in-Excel-Step-5.jpg","smallWidth":460,"smallHeight":285,"bigWidth":728,"bigHeight":451,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/76\/Divide-in-Excel-Step-6.jpg\/v4-460px-Divide-in-Excel-Step-6.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/76\/Divide-in-Excel-Step-6.jpg\/v4-728px-Divide-in-Excel-Step-6.jpg","smallWidth":460,"smallHeight":285,"bigWidth":728,"bigHeight":451,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    选择"格式化单元格"。
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/59\/Divide-in-Excel-Step-7.jpg\/v4-460px-Divide-in-Excel-Step-7.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/59\/Divide-in-Excel-Step-7.jpg\/v4-624px-Divide-in-Excel-Step-7.jpg","smallWidth":460,"smallHeight":374,"bigWidth":624,"bigHeight":508,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    确定你希望保留多少个小数位并点击"确定"。
    • 通过该设置，你将可以在数据上应用数学公式，而不会把这些数字以文本的格式来对待。
    广告
方法 3
方法 3 的 4:

方法 确定单元格名称

下载PDF文件
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/cd\/Divide-in-Excel-Step-8.jpg\/v4-460px-Divide-in-Excel-Step-8.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/cd\/Divide-in-Excel-Step-8.jpg\/v4-728px-Divide-in-Excel-Step-8.jpg","smallWidth":460,"smallHeight":285,"bigWidth":728,"bigHeight":451,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    掌握单元格的命名方式能帮助你更好地输入Excel公式。
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/6a\/Divide-in-Excel-Step-9.jpg\/v4-460px-Divide-in-Excel-Step-9.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6a\/Divide-in-Excel-Step-9.jpg\/v4-728px-Divide-in-Excel-Step-9.jpg","smallWidth":460,"smallHeight":285,"bigWidth":728,"bigHeight":451,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    该单元格将以字母在前、数字在后的形式标注。例如，"C2"。
    广告
方法 4
方法 4 的 4:

方法 创建Excel除法公式

下载PDF文件
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/2a\/Divide-in-Excel-Step-10.jpg\/v4-460px-Divide-in-Excel-Step-10.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2a\/Divide-in-Excel-Step-10.jpg\/v4-728px-Divide-in-Excel-Step-10.jpg","smallWidth":460,"smallHeight":285,"bigWidth":728,"bigHeight":451,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    这可能是位于"汇总"列下方或末尾行的某一单元格。
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/e6\/Divide-in-Excel-Step-11.jpg\/v4-460px-Divide-in-Excel-Step-11.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e6\/Divide-in-Excel-Step-11.jpg\/v4-728px-Divide-in-Excel-Step-11.jpg","smallWidth":460,"smallHeight":285,"bigWidth":728,"bigHeight":451,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    这是位于数据表顶部的一个水平输入栏。公示栏是位于字母"fx"旁的一个空白空间。
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/3d\/Divide-in-Excel-Step-12.jpg\/v4-460px-Divide-in-Excel-Step-12.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3d\/Divide-in-Excel-Step-12.jpg\/v4-728px-Divide-in-Excel-Step-12.jpg","smallWidth":460,"smallHeight":285,"bigWidth":728,"bigHeight":451,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/c9\/Divide-in-Excel-Step-13.jpg\/v4-460px-Divide-in-Excel-Step-13.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c9\/Divide-in-Excel-Step-13.jpg\/v4-728px-Divide-in-Excel-Step-13.jpg","smallWidth":460,"smallHeight":285,"bigWidth":728,"bigHeight":451,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    该数字将被进行除法。例如，"C2"。
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/2f\/Divide-in-Excel-Step-14.jpg\/v4-460px-Divide-in-Excel-Step-14.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2f\/Divide-in-Excel-Step-14.jpg\/v4-728px-Divide-in-Excel-Step-14.jpg","smallWidth":460,"smallHeight":285,"bigWidth":728,"bigHeight":451,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/11\/Divide-in-Excel-Step-15.jpg\/v4-460px-Divide-in-Excel-Step-15.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/11\/Divide-in-Excel-Step-15.jpg\/v4-728px-Divide-in-Excel-Step-15.jpg","smallWidth":460,"smallHeight":285,"bigWidth":728,"bigHeight":451,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    该数字将用于和第一个数字进行除法。
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/e2\/Divide-in-Excel-Step-16.jpg\/v4-460px-Divide-in-Excel-Step-16.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e2\/Divide-in-Excel-Step-16.jpg\/v4-728px-Divide-in-Excel-Step-16.jpg","smallWidth":460,"smallHeight":285,"bigWidth":728,"bigHeight":451,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    答案将显示在选中的单元格中。
    广告


你可能还喜欢

如何
求直角三角形斜边的长度
如何
因式分解三次多项式
如何
装病
如何
使用算盘
如何
计算百分数
如何
计算功率
求三阶矩阵的逆矩阵
如何
计算三角形面积
如何
读尺子上的刻度
如何
计算三角形的周长
如何
计算角度
如何
解三次方程
如何
计算矩阵乘法
如何
按照APA格式引用英文网址
广告

参考

  1. http://www.homeandlearn.co.uk/excel2007/excel2007s4p3.html
  2. http://office.microsoft.com/en-us/excel-help/divide-numbers-HP003056142.aspx

关于本wikiHow

其他语言
本页面已经被访问过66,109次。

这篇文章对你有帮助吗？

广告