另一个excel配方的情况 [英] Another excel formula situation

问题描述

我希望能够以秒为单位显示（+4.15）的差异，有时甚至会以（-4.15）的形式显示差异，并包含括号和加号/减号。

如何使用公式显示34.47-30.32，所以出来知道差异是正还是负4.15？

现在解决了，除了我的下一个问题很小，但以0结尾的任何数字（例如4.10）将显示为4.1，而不需要额外的0.使用公式在第一个评论中给出，我无法格式化，以正确显示4.10。可能吗？

解决方案

您可以使用excel中的常规单元格格式选项来实现这一点。 p>

格式化您的单元格以这种方式显示数字。
或者如果您需要除已经可用的选项之外的其他选项，请使用自定义格式。

I want to be able to display a difference in seconds as (+4.15) or sometimes negatively as (-4.15) and include the parentheses and plus/minus sign.

How can I use a formula to display 34.47-30.32 so it comes out knowing whether or not the difference is positive or negative 4.15?

This is solved now except my next issue is small, but any number ending in 0, such as 4.10, will display as 4.1, without the extra 0. Using the formula given in the first comment, I can't format this to show exactly 4.10. Is it possible? not even cell formatting to show two decimal places works

解决方案

You can achieve this with the regular cell formats option in excel.

Format your cells to show the number in this way. Or if you need something other than the already available options, then use custom formats.

这篇关于另一个excel配方的情况的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！