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

QBERT

New Member
Joined
Oct 13, 2004
Messages
38
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
  3. Mobile
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
Joined
May 15, 2003
Messages
29,536
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
Joined
Oct 13, 2004
Messages
38
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
  3. Mobile
Indeed. Thank you so much!

Qbert
 

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

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
Top