Numbers question

paulprd · Jan 31, 2017

Hi, can anyone tell me how to fix a formula to a cell, e.g. I want to display the contents of a5 in a3. This I can do using the = so a3=a5. But I they want to add a row which forces the row down so a5 becomes a6.

Hope this makes sense. Thanks in advance !

Paul

Sawday · Jan 31, 2017

In Excel you put a $ sign before the column or row value (or both) ie a$5. Not sure if this works for numbers too.

paulprd · Jan 31, 2017

paulprd said:
Hi, can anyone tell me how to fix a formula to a cell, e.g. I want to display the contents of a5 in a3. This I can do using the = so a3=a5. But I they want to add a row which forces the row down so a5 becomes a6.

Hope this makes sense. Thanks in advance !

Paul

Hi Sawday. Thanks for the suggestion ! Really appreciated ! I did try that but will go back and try once more just in case.

Best

Paul

Gandalph · Jan 31, 2017

Try highlighting the a3 cell then type SUM=(a5).

paulprd · Feb 1, 2017

Thanks Gandalf will give that a try. I can see how that could work! Best paul

paulprd · Feb 1, 2017

Hi Gandalf. Unfortunately that does not work either. It does work if you have a number cell, but as I need a txt cell it won't let me apply a sum function. Good idea tho, worked with numbers.

Numbers question

paulprd

Sawday

paulprd

Gandalph

paulprd

paulprd

Shop Amazon