If then else

Terryl - Sep 13, 2017 at 06:44 AM
 Blocked Profile - Sep 13, 2017 at 11:22 PM

Please help me with a formula for Excel(?) in Open Office.

I want to say....If =IF(G59=date;then_date;otherwise_0)
I am trying to say if I insert a manual date, then the value in C59 is true else it is 0. This is to show that the amount in C59 is true if paid on a date.

I would sincerely appreciate your help.

Thank you,

1 response

Blocked Profile
Sep 13, 2017 at 11:22 PM
You can try:

Untested, but then again, your example references two separate cells, so apply it as you see fit!