Need to know how formula to get the status

[ragavajothee]

Hi All ,

I want to know the formula to give the conclusion in inspection status as ..

When the inspection completed it should say . " Inspection Completed " , If inspection completed date is empty and inspected dated is filled , it should say " Inspection in Progress" , if both are empty , it should say " Scheduled on " Date in the respective cell " . Please give a solution for this . Thanks .

 

[arthurbr]

Please add your Excel version to your profile. Thx

 

[AhoyNC]

Something like this?

Book1
	A	B	C	D	E
1	Scheduled	Offered date	Inspected date	Inspection Com	Inspection status
2	11/15/24	11/14/24	11/19/24	11/19/24	Inspection Completed
3	11/15/24	11/14/24	11/19/24		Inspection in Progress
4	11/15/24	11/14/24			Scheduled on 11/15/24
Sheet1

Cell Formulas
Range	Formula
E2:E4	E2	=IF(D2<>"","Inspection Completed ",IF(C2<>"","Inspection in Progress","Scheduled on"&" "&TEXT(A2,"M/D/Y")))