# IF Statement Help = (Greater Than and Less Than Statements) and Blank Cells

#### QBERT

##### New Member
I have three columns as follows:

Column A: Provides the number of days permitted to complete a task

Column B: Provides the number of days that it actually took to complete the task

Column C: This is where I need my IF Statement to calculate a simple Yes or No if the Actual Days to complete were greater than 0 but less than or Equal to the Days Permitted that it should say, "Yes". If the actual days cell is blank or greater than the days permitted it should say "No"

I have tried: =IF(0<B1<=A1, "Yes", "No")

Another problem I encounter is that several entries in my column B are Blank because the job isn't finished but from another column I know the project will be late (today's date vs due date), so I am trying to accommodate for blank values as well should should result in a "No" response. There will never be a zero in the actual days cell. At minimum the fastest any work can be done is 1 day.

Column C results will be used to help determine how often we are on time, or not on time. It would be fun to show delivered ahead of schedule, as well, but that is beyond my knowledge at this point.

Thanks,

QBert

### Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

#### Smitty

##### Legend
Welcome to the Board!

Does this do what you want:

Book1
ABC
1Days PermittedActual DaysOn Time?
220No
3107Yes
459No
Sheet1
Cell Formulas
RangeFormula
C2=IF([@[Actual Days]]="","No",IF([Actual Days]<=[Days Permitted],"Yes","No"))
C3=IF([@[Actual Days]]="","No",IF([Actual Days]<=[Days Permitted],"Yes","No"))
C4=IF([@[Actual Days]]="","No",IF([Actual Days]<=[Days Permitted],"Yes","No"))

HTH

Last edited:

#### QBERT

##### New Member
Indeed. Thank you so much!

Qbert

Replies
5
Views
429
Replies
3
Views
178
Replies
3
Views
69
Replies
3
Views
262
Replies
5
Views
316

1,171,877
Messages
5,878,021
Members
433,311
Latest member
novalion

### 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.

### Which adblocker are you using?

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

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