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
iMac, iOS 7.1.1
I suggest disabling the "Use header names as labels" in preferences for Numbers:
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.
The formula contains a syntax error
