If then else

Closed
Report
-
 Blocked Profile -
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 reply


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