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

#### rentonhighlands

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

### Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

#### jtakw

##### Well-known Member
Hi,

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

#### rentonhighlands

##### Board Regular
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

##### Well-known Member
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...

Last edited:

Replies
2
Views
64
Replies
2
Views
27
Replies
3
Views
62
Replies
1
Views
124
Replies
3
Views
61