Excel基于kg / gr增加 /减少十进制

发布于 2025-01-17 16:21:37 字数 348 浏览 0 评论 0原文

在我的表中，我称量了 4 个样品。我需要报告这些样本的平均值，因此我编写了一个简单的函数。然而，对于客户#1，我需要以千克为单位报告，小数点后 1 位；对于客户 2，我需要以 Gr 为单位，小数点后为 0 报告。所以我写了下面的公式：

=IF(test="customer#1";ROUND(AVERAGE(M26:O29);1);ROUND(AVERAGE(M26:O37);0);

这可以正确计算值，但是 GR 仍然显示 1 位小数 (.0)，即使它没有被计算。是否可以告诉Excel在使用克时减去小数，但在使用千克时添加小数。

我尝试过使用条件格式来显示正确的数字，但小数点仍然“隐藏”在表面之下。

原文

In my sheet I'm weighing 4 samples. I need to report the average of these samples so I've written a simple function. However for customer #1 I need to report them in KG's with 1 decimal and to customer 2 I need to report them in Gr's with 0 decimals. So I wrote the formula below:

=IF(test="customer#1";ROUND(AVERAGE(M26:O29);1);ROUND(AVERAGE(M26:O37);0);

This calculates the values correctly however the GR's still display 1 decimal (.0) even though it doesn't get calculated. Is it possible to tell Excel to subtract a decimal when using grams but add it when using kilograms.

I've tried to with conditional formatting which displays the correct number but the decimal is still "hiding" beneath the surface.

分享到QQ

分享到微博