As a newbie/silver surfer to Libre office I seem to have ,what maybe a simple error, constucting an IF formula. I am making a simple profit/loss spreadsheet.
I am try ing to apply formula to cell H17. If cell H16 is empty i want cell H17 to be empty,but if H16 has a figure I want H17 to contain difference between H16 and H15
I have tried the following =if(H16 "";"";"(=SUM(H16-H15))") but keep getting err 509
can someone point out the error please.