• Entering Formulas – =

    Author
    Topic
    #1768515

    Is there a way to enter simple formulas like b1+c1 or 150-25 without first entering an = sign?

    Viewing 1 reply thread
    Author
    Replies
    • #1779775

      The only way I know is +b1+c1 or +150-25

      I susoect that doesn’t help you much though.

    • #1779814

      Try: Tools / Options / Transition / Transition Formula Entry

      Using the help button on the Options form states that this option:
      “Converts formulas entered in Lotus 1-2-3 release 2.2 syntax to Microsoft Excel syntax, and makes names defined in Microsoft Excel behave like names defined in Lotus 1-2-3.”

      Check the option box and type 1+2+3 into a cell and hit Enter, and Excel automatically insert a = into the formula and return a value of 6, instead of returning the undesired text string.

      This is good for entering simple formulas, but it can also cause some undesired results. This is particularly true when keying in dates or other numerical-looking data that contain operator-type characters. Keying 3/7/01 results in 0.428571 instead of the date; 800-555-1212 yields -967.

      • #1779822

        Thanks. That is what I was looking for.

    Viewing 1 reply thread
    Reply To: Entering Formulas – =

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: