Report

If then else

Ask a question Terryl - Last answered on Sep 13, 2017 at 11:22 PM by ac3mark
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


Helpful
+0
plus moins
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!
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!