Excel Formulas not working

dvbeatty

macrumors newbie
Original poster
May 15, 2011
5
0
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.
 

alpop

macrumors newbie
Dec 30, 2013
2
0
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.
 
Comment

rc135tx

macrumors member
Feb 15, 2010
37
3
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:
 
Comment

Similar threads

Register on MacRumors! This sidebar will go away, and you'll see fewer ads.