Menu
Ask a question Report

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
Excel Ask a question Report
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

Report Respond to ac3mark
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.
Report Respond to bowmankailee
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.
Report Respond to ac3mark
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.
Report Respond to ac3mark
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
Reply Ask a question