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.
0
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.
0
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.
0
Blocked Profile
Feb 20, 2019 at 03:05 PM
Remove the brackets too.

=if (due> pay, true, false)
0

Similar discussions

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

3 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 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