Greater then and = to: =IF(CB12>=BY12,"YES",NO)

[rentonhighlands]

Hello
my formulas is =IF(CB12>=BY12,"YES",NO)
How can I make it say: IF B12 is greater then "AND" =B12

 

[jtakw]

Hi,

Please explain your question again, it's confusing.

How can B12 be Greater Than AND Equal to B12 (itself) at the same time?

 

[rentonhighlands]

How about "OR" instead of "and" I am working to compare dates. some times the date falls in the same month. For those I want excel to say yes

 

[jtakw]

I'm still confused, are you talking about comparing B12 to B12?, B12 can ONLY be EQUAL to B12, no other possibilities.

Or are you talking about CB12 and BY12?
If you are, your formula is Already saying GREATER THAN or EQUAL TO.

Perhaps you can show a couple of samples and expected results...