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
5 replies

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

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

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.