Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

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?
See more

1 reply

Answer 1 / 1

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
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
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.
Report
Blocked Profile
Remove the brackets too.

=if (due> pay, true, false)
Ask a question