IF function?

Closed

bowmankailee Posts 2 Registration date Tuesday 19 February 2019 Status Member Last seen 20 February 2019 - 19 Feb 2019 à 14:34
Blocked Profile - 20 Feb 2019 à 15:05

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?

1 response

Réponse 1 / 1

Blocked Profile
19 Feb 2019 à 14:39

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 19 February 2019 Status Member Last seen 20 February 2019
20 Feb 2019 à 14:05

Yes they are named that way. I tried removing the @ symbol, and still gives just the answer of No for all cells.

Blocked Profile
20 Feb 2019 à 14:25

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
20 Feb 2019 à 15:05

Remove the brackets too.

=if (due> pay, true, false)

Similar discussions

"Sorry, this feature isn't available ... " how to fix this?

How to disable Fn keys

fn key + space bar?

VBA Find function

Similar discussions

Subscribe To Our Newsletter!