Excel Formulas not working

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

  1. dvbeatty macrumors newbie

    Joined:
    May 15, 2011
    #1
    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

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

    Joined:
    May 15, 2011
  4. alpop macrumors newbie

    Joined:
    Dec 30, 2013
    #4
    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

    rc135tx

    Joined:
    Feb 15, 2010
    #5
    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