IF function?

Posts
2
Registration date
Tuesday February 19, 2019
Status
Member
Last seen
February 20, 2019
- - Latest reply: ac3mark
Posts
13036
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
- Feb 20, 2019 at 03:05 PM
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?
See more 

1 reply

Posts
13036
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
1468
0
Thank you
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.
bowmankailee
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.
ac3mark
Posts
13036
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
1468 -
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.
ac3mark
Posts
13036
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
1468 -
Remove the brackets too.

=if (due> pay, true, false)
Respond to ac3mark