Calculation without equal

Calculation without equal
Last Updated on 28/11/2021
Reading time: < 1 minute

Secretary problem 😉

I always wonder why there is a calculator close to a computer. It's totally ridiculous especially if you have Excel on your computer 😉

But a secretary told me one day "I'm fed up to start a formula with ="

Excel option


In fact, there is a way to do calculations without equal

  1. Go in the menu Files>Options>Advanced
  2. Scroll down until you reach the end of the options
  3. In the section Lotus compatibility setting, check transition formula entry.
Calculation_without_equal

What happen's now in Excel?

Now, when you perform a calculation, Excel will add for you the symbol equal and display the result of your calculation.

Important: this option is not permanent.

When you close Excel you have to reactivate this option if you want to avoid starting your calculation with equal.

Calculation_without_equal_2

This option is not applicable to all the worksheets of your workbook. In fact, you have to select the worksheet where you want to have this option activated.

2 Comments

  1. Chuck
    08/01/2022 @ 15:17

    Wow... I am a long time CPA and long ago made the trans from Lotus to Excel. This is literally the only thing that has driven me crazy about not being able to do... THANK YOU!!!

    Reply

    • Frédéric LE GUEN
      08/01/2022 @ 17:34

      You're welcome 🙂

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Calculation without equal

Reading time: < 1 minute
Last Updated on 28/11/2021

Secretary problem 😉

I always wonder why there is a calculator close to a computer. It's totally ridiculous especially if you have Excel on your computer 😉

But a secretary told me one day "I'm fed up to start a formula with ="

Excel option


In fact, there is a way to do calculations without equal

  1. Go in the menu Files>Options>Advanced
  2. Scroll down until you reach the end of the options
  3. In the section Lotus compatibility setting, check transition formula entry.
Calculation_without_equal

What happen's now in Excel?

Now, when you perform a calculation, Excel will add for you the symbol equal and display the result of your calculation.

Important: this option is not permanent.

When you close Excel you have to reactivate this option if you want to avoid starting your calculation with equal.

Calculation_without_equal_2

This option is not applicable to all the worksheets of your workbook. In fact, you have to select the worksheet where you want to have this option activated.

2 Comments

  1. Chuck
    08/01/2022 @ 15:17

    Wow... I am a long time CPA and long ago made the trans from Lotus to Excel. This is literally the only thing that has driven me crazy about not being able to do... THANK YOU!!!

    Reply

    • Frédéric LE GUEN
      08/01/2022 @ 17:34

      You're welcome 🙂

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *