Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Numbers: Syntax error

I apologise in advance, because I know this is a very basic question😊! I have an accounts spreadsheet for my new small business and have already successfully completed the calculations for March....but can't remember how I did it (and the formula shown doesn't really help). So, I have a column for 'Mileage' in which I want to put the mileage for that day, and have it multiplied by 0.45 pence per mile. I click on the cell, and try the following formula: =F3*0.45

User uploaded file

but each time I get a Syntax error that reads: "This formula can’t reference its own cell, or depend on another formula that references this cell."

Is it because I haven't yet entered the data (daily mileage) that I want multiplied? I know it's something very simple, but can't for the life of me work it out!

Any help (in ABC/123 language please!) will be very gratefully received! TIA

MacBook Pro (Retina, 13-inch,Early 2015), macOS High Sierra (10.13.4)

Posted on May 11, 2018 8:28 AM

Reply
Question marked as Top-ranking reply

Posted on May 11, 2018 12:54 PM

A formula in F3 can't reference F3. It can only reference other cells.


So I suggest entering the millage in the Mileage column and add another column with the formula =F3*0.45, filled down.


You could also directly enter the number for the mileage and multiply. For example, if the mileage were 100 you would enter the formula =100*0.45. But it is better practice not to have a "hard-coded" formula like that.


SG

5 replies
Sort By: 
Question marked as Top-ranking reply

May 11, 2018 12:54 PM in response to Mitramonday

A formula in F3 can't reference F3. It can only reference other cells.


So I suggest entering the millage in the Mileage column and add another column with the formula =F3*0.45, filled down.


You could also directly enter the number for the mileage and multiply. For example, if the mileage were 100 you would enter the formula =100*0.45. But it is better practice not to have a "hard-coded" formula like that.


SG

Reply

May 11, 2018 1:09 PM in response to SGIII

Many thanks, SGIII - that now throws up another issue, in that in B3, I had the formula =SumC3:O3. If I have a separate column for the number of miles, I want to NOT include that column (F) in the sum...how do I do that? I have tried =sum C3:E3+G3:O3 and = sum (C3:E3)+(G3:03) both of which throw up a syntax error again:

User uploaded file

Reply

Numbers: Syntax error

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.