Excel Formulas not working

Discussion in 'Mac Apps and Mac App Store' started by dvbeatty, Sep 27, 2011.

  1. dvbeatty macrumors newbie

    May 15, 2011
    Hi, I am using Mac Excel and when I enter a formula, it doesn't calculate, it just shows the formals as written. The formula I am using is =f1&f2. This formula works if I create a new workbook, but not in the one I have open. I have checked the preferences/Calculation and the radio button to automatically calculate is selected. Any suggestions on how to make this work much appreciated.
  2. mjo404 macrumors newbie

    Jul 5, 2010
    make sure the cell is formatted correctly... i.e. not formatted as "text"
  3. dvbeatty thread starter macrumors newbie

    May 15, 2011
  4. alpop macrumors newbie

    Dec 30, 2013
    Excel formulas not working, they are copied as text

    I tried all suggestions found here and elsewhere to no avail. Then I did this: I copied my table filled with data that needs calculations, open a new excel file, pasted the table, and in the bottom right corner of the new pasted table there is in icon that displays two options after you click it:

    - Keep source formatting (this is selected by default)
    -Match destination formatting (and I selected this option)

    Hope it helps.
  5. rc135tx macrumors member


    Feb 15, 2010
    Not sure what you're trying to do with the two cells, so the following may just be ignorant rambling.

    "&" concatenates the contents/results of two cells.

    If f1 is "Hello" and f2 is " there", the result of =f1&f2 will be "Hello there".

    If f1 is =7+1 & f2 is =8+2, then the result of =f1&f2 will be 810.

    If that's not what you were expecting, tell us what you wanted to do. :apple:

Share This Page