I need to say
If (A2+B2=0) then D2=0, ELSE D2=(A2+B2+D1)
how do I do this
[Solved] Problems with Calc
[Solved] Problems with Calc
Last edited by John17 on Tue Aug 21, 2018 4:28 pm, edited 2 times in total.
OpenOffice 4.1.3 on Windows 10
Re: Problems with Calc
In D2 put the formula
Code: Select all
IF(A2+B2=0;0;A2+B2+D1)
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.