If then else

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

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,
Terry


1 response

Blocked Profile
Sep 13, 2017 at 11:22 PM
You can try:
=IF(G59=isdate(G59),C59,0)

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