# Help with IF, dates and great or less than formula

#### mol

##### New Member
I am sure this is an easy question, but I am really struggling. I will have a date (1/6/2006) in cell C11. I need the formula in cell D18 to multiply the number in d17 by .445 if c11 is greater than 1/6/2006 or to multiply by .485 if the date is less than 1/5/2006

### Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

#### starryeyed

##### Board Regular
Try =IF(C11>38723,D17*0.455,D17*0.485)

or Try =IF(C11>=38723,D17*0.455,D17*0.485

#### mol

##### New Member
This one doesn't work. I copied and pasted it even. It just returns D17*.485 regardless of the date in C11.

I appreciate the help, though. Any others?

#### starryeyed

##### Board Regular
It works fine on mine

I take it you are using American dates, not British ones?

This one is the best to use if you want to include 1/6/06
=IF(C11>=38723,D17*0.455,D17*0.485)

#### mol

##### New Member
Correct, am using American dates. I have been researching this until I am nearly blue in the face. I just cannot imagine why it doesn't work.

#### mol

##### New Member
Not sure what I did different, but after playing with the date in general format, I did get the formula to work properly. I cannot thank you enough!!!!

Replies
19
Views
342
Replies
4
Views
199
Replies
1
Views
267
Replies
6
Views
650
Replies
2
Views
130

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,855
Messages
5,834,001
Members
430,250
Latest member
Reggie Mcqueen

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back