If then else

Terryl - Sep 13, 2017 at 06:44 AM - Latest reply: ac3mark 9999 Posts Monday June 3, 2013Registration dateModeratorStatus July 20, 2018 Last seen
- 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


See more 

Your reply

1 reply

ac3mark 9999 Posts Monday June 3, 2013Registration dateModeratorStatus July 20, 2018 Last seen - Sep 13, 2017 at 11:22 PM
0
Thank you
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!
Respond to ac3mark