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

[QBERT]

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

 

[Smitty]

Welcome to the Board!

Does this do what you want:

Book1
	A	B	C
1	Days Permitted	Actual Days	On Time?
2	20		No
3	10	7	Yes
4	5	9	No
Sheet1

Cell Formulas
Range	Formula
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

 

[QBERT]

Indeed. Thank you so much!

Qbert