Put the cursor between the second semicolon and the closing bracket and type the what to do if false part.Put the cursor between the two semicolons and type the what to do if true part.Put the cursor between the opening bracket and the first semicolon and type the test part.Type 'IF()' and put the cursor between the brackets.That way you always know that all brackets are in matching pairs. When I type moderately complicated formulae involving brackets, I always type the opening and closing brackets at the same time, then move the cursor to between them. Since the brackets in your formula are all over the place and not even the same number of opening as closing, it's probably easier to start again than try to decipher the mess you have. The IF function is then closed without the other two arguments, then followed by a semicolon (not a valid operator), then an expression, then an unpaired closing bracket.

In your formula (Q3>0 ((Q3*F3)/J3)-1)*100 is the test, which is not a valid expression. Secondly the IF function needs to be of the form =IF( test what to do if true what to do if false).

Your formula is obviously wrong as it contains five closing brackets but only four opening. First of all brackets need to be in matching pairs.

Err 502 openoffice