13 Replies Latest reply: Jul 4, 2013 7:28 AM by Yellowbox
salkat Level 1 Level 1

i've copied cell with formula to another cell. Edit new cell (changed the range). Syntax error.

What error - I just changed one number?


MacBook Air, OS X Mountain Lion (10.8.4)
Solved by Yellowbox on Jul 4, 2013 3:13 AM Solved

Hi Salkat,

 

I've typed "f5" but Numbers changed it to 06.13 продвижение

 

I see! You have ticked Numbers > Preferences > General > Use Header cell names as references.

 

working formula: =05.13 продвижение/СУММ(Конверсия :: E24:E27)

Cell G8 of the second Table:

 

=F5/SUM(First Table E24:E27)

=3 700/(7+9+3+4)

=3 700/23

=160.86956

=161 (rounded).

 

I agree.

 

not working formula: =06.13 продвижение/СУММ(Конверсия :: E28:E31)

 

Where is 06.13 ? Is it G5 ?

 

=G5/SUM(First Table E28:E31)

=4 000/(3+0+0+0)

=4 000/3

=1 333.333

 

What are we doing wrong?

 

Regards,

Ian.

  • Yellowbox Level 6 Level 6
    expertise.macosx
    Mac OS X

    Hi salkat,

     

    More information will help. What is the formula? From which cell did you copy and to which cell did you paste it? What did you change after copying?

     

    A screen shot of a small part of your Table will help (remove all personal details first).

     

    Regards,

    Ian.

  • Jerrold Green1 Level 7 Level 7

    Sal,

     

    Copy and Paste the two formulas from your Numbers document to your post here so we can compare them.

     

    Jerry

  • salkat Level 1 Level 1

    working formula: =05.13 продвижение/СУММ(Конверсия :: E24:E27)

    not working formula: =06.13 продвижение/СУММ(Конверсия :: E28:E31)

  • Yellowbox Level 6 Level 6
    expertise.macosx
    Mac OS X

    Hi Salkat,

     

    I used Google Translate from Russian to English:

     

    продвижение/СУММ(Конверсия

    promotion / SUM(conversion

     

    Thank you for teaching me some Russian!

     

    I think that the problem lies in the Cell changes:

     

    E24:E27 to E28:E31

     

    Please post a screen shot to show those Cells. Are they all in the same Table?

     

    I am struggling here. I need to know how many Sheets (Листы) and how many Tables (Таблицы) are in your document. Please post a screen shot of your Sheets Pane, for example:

     

    Screen Shot 2013-07-04 at 12.26.47 AM.png

     

    Пожалуйста, прости мои бедные русские,

    С уважением,

    Ян.

     

     

    Please forgive my poor Russian,

    Regards,

    Ian.

  • salkat Level 1 Level 1

    screenshot копия.jpgI've typed "f5" but Numbers changed it to 06.13 продвижение Sorry for you have to make unnesessary translation

     

    Yes, all those cells in same Table

  • Yellowbox Level 6 Level 6
    expertise.macosx
    Mac OS X

    Hi Salkat,

     

    I've typed "f5" but Numbers changed it to 06.13 продвижение

     

    I see! You have ticked Numbers > Preferences > General > Use Header cell names as references.

     

    working formula: =05.13 продвижение/СУММ(Конверсия :: E24:E27)

    Cell G8 of the second Table:

     

    =F5/SUM(First Table E24:E27)

    =3 700/(7+9+3+4)

    =3 700/23

    =160.86956

    =161 (rounded).

     

    I agree.

     

    not working formula: =06.13 продвижение/СУММ(Конверсия :: E28:E31)

     

    Where is 06.13 ? Is it G5 ?

     

    =G5/SUM(First Table E28:E31)

    =4 000/(3+0+0+0)

    =4 000/3

    =1 333.333

     

    What are we doing wrong?

     

    Regards,

    Ian.

  • salkat Level 1 Level 1

    wrong is 'syntax error' instead of calculation

     

    If I create the new formula - everything is ok, but if I edit copied formula - I get syntax error instead of calculation

  • Yellowbox Level 6 Level 6
    expertise.macosx
    Mac OS X

    Hi Salkat,

     

    This works:

    =F5/SUM(First Table::E24:E27)

     

    If you copy and paste, where are you pasting?

     

    If you paste into another Column, the formula will change both F and E (relative references)

     

    Perhaps absolute references ($) will help.

     

    Regards,

    Ian.

  • salkat Level 1 Level 1

    Thanks Ian. I know about '$', but problem in other thing: any edited formula gives syntax error. $ is not always helps. For instance, first formula need to be =F5/SUM(First Table::E24:E27), second - =E5/SUM(First Table::E28:E32). So I have to edit formula... and getting an error

  • Yellowbox Level 6 Level 6
    expertise.macosx
    Mac OS X

    Hi Salkat,

     

    The formula in G8 works.

     

    Your screen shot shows red triangles (syntax errors) in Column H.

     

    Your second formula should work:

     

    =E5/SUM(First Table::E28:E32)

     

    E5 contains 5 331

    E28 contains 3

    E29 to E32 appear to be empty. Even if they contain spaces, SUM will ignore them and treat them a zero. So:

     

    =E5/SUM(First Table::E28:E32)

    =5 331/(3+0+0+0+0)

    =5 331/3

    =1 777

     

    What are the cell formats in Column E ?

     

    If you like, click on my name to get my email address and send me the document. Make a copy first, and then delete all personal information.

     

    Regards,

    Ian.

     


  • salkat Level 1 Level 1

    Thank you, Ian, turning off Numbers > Preferences > General > Use Header cell names as references checkbox was helped to resolve the problem - now I can edit cells

  • salkat Level 1 Level 1

    Thenk you for your time and attention!

  • Yellowbox Level 6 Level 6
    expertise.macosx
    Mac OS X

    Hi Salkat,

     

    Thank you for your reply. It will help other people. I enjoyed working through this problem. I am glad that you can now edit.

     

    Regards,

    Ian.