[Solved] Problems with Calc

Discuss the spreadsheet application
Post Reply
John17
Posts: 2
Joined: Tue Aug 21, 2018 9:44 am

[Solved] Problems with Calc

Post by John17 »

I need to say
If (A2+B2=0) then D2=0, ELSE D2=(A2+B2+D1)
how do I do this
Last edited by John17 on Tue Aug 21, 2018 4:28 pm, edited 2 times in total.
OpenOffice 4.1.3 on Windows 10
FJCC
Moderator
Posts: 9271
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Problems with Calc

Post by FJCC »

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.
Post Reply