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

The formula contains a syntax error

Hi i keep getting the following message errors The formula contains a syntax error. I have working with lookup formula so when i change hours is changes the price. Just need to get a total for hours x number of people x price cant seem to get there.


Thanks Danny


User uploaded file

iMac, iOS 7.1.1

Posted on Jul 24, 2014 6:48 PM

Reply
2 replies
Sort By: 

Jul 24, 2014 9:30 PM in response to dannytype1

It's hard to say from your screenshot, but it appears you are either attempting to make a cell reference itself, or the reference is empty.


There is no need for the parentheses since algebraic hierarchy will result in the same answer.


Capture the row and column data, post a more descriptive screenshot, or describe the required calculation in greater detail.

Reply

The formula contains a syntax error

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