Previous Topic Next Topic

IF function?

Closed
bowmankailee Posts 2 Registration date Tuesday February 19, 2019 Status Member Last seen February 20, 2019 - Feb 19, 2019 at 02:34 PM
 Blocked Profile - 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?
Related:

1 response

Answer 1 / 1
Blocked Profile
Feb 19, 2019 at 02:39 PM
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
Feb 20, 2019 at 02:05 PM
Yes they are named that way. I tried removing the @ symbol, and still gives just the answer of No for all cells.
Blocked Profile
Feb 20, 2019 at 02:25 PM
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
Feb 20, 2019 at 03:05 PM
Remove the brackets too.

=if (due> pay, true, false)

Similar discussions

"Sorry, this feature isn't available ... " how to fix this?
Anonymous User -
heclam -

3 responses
How to disable Fn keys
HENRY -
ZiaRahman -

30 responses
If cell A1 has text then cell B2 has today's Date
Sasha -
ac3mark -

1 response
help me to add particular cells
mathewmunna -
mathew munna -

2 responses