IF function? [Closed]

Report
Posts
2
Registration date
Tuesday February 19, 2019
Status
Member
Last seen
February 20, 2019
-
 Blocked Profile -
I am trying to figure out a function, that will give me a result of Yes or No, if the dates are matching or not.

This is the function I am using, but it just gives me results of all No, when most dates do match to the other date

=IF([@[Due Date]]=[@[Date Paid]],"Yes","No")

I'm not sure if this is the correct function to even use for this?

1 reply


Are the two RANGES named what you are calling them? Remove the @. Try to reference the cell directly and see if it returns what you want. If it does, then you can move to the named region or RANGE.
Posts
2
Registration date
Tuesday February 19, 2019
Status
Member
Last seen
February 20, 2019

Yes they are named that way. I tried removing the @ symbol, and still gives just the answer of No for all cells.
Blocked Profile
Ok so try the formula referencing the actual cell location. Did that work? In other words, if DUEDATE is cell A1, then put A1 in formula.
Blocked Profile
Remove the brackets too.

=if (due> pay, true, false)