Excel中=和= +之间有什么区别

时间:2022-03-28 22:57:44

I am beginner in Excel. I have a workbook in which the formula column is defined as

我是Excel的初学者。我有一个工作簿,其中公式列定义为

=+TEXT($A36,"mmm"), but even if I give =Text($A36,"mmm") it is returning the Month.

= + TEXT($ A36,“mmm”),但即使我给= Text($ A36,“mmm”)它也会返回月份。

What is the difference in using =+ and + in Excel?

在Excel中使用= +和+有什么区别?

Will it changes the functionality in any ways?

它会以任何方式改变功能吗?

2 个解决方案

#1


4  

There is no difference. It's the exact same thing.

没有区别。这是完全相同的事情。

It comes from an old syntax used in Lotus

它来自Lotus中使用的旧语法

#2


12  

This is simply a legacy way of doing it. From Lotus 123 I believe. It makes absolutely no difference to the functionality.

这只是一种传统的做法。从莲花123我相信。它对功能完全没有影响。

#1


4  

There is no difference. It's the exact same thing.

没有区别。这是完全相同的事情。

It comes from an old syntax used in Lotus

它来自Lotus中使用的旧语法

#2


12  

This is simply a legacy way of doing it. From Lotus 123 I believe. It makes absolutely no difference to the functionality.

这只是一种传统的做法。从莲花123我相信。它对功能完全没有影响。