If statement

[shiraz50]

Hi Team

I need some help. No of days

No of days : Column FU : IF column FS8 has a date then FU must show the number of days from FS8-N8 however if FS8 = blank then look into FT8 to see if if is > than Today & N8 , if so then FT8-N8
Delivery status : Column FV : If column FS8 has a date then DIFFERENECE BETWEEN FS8 - N8 NEEDS TO SAY "Delivered late" , Delivered Early , IF NOT THEN LOOK INTO column FT8 - N8 TO GIVE A STATUS OF Delivered late" , Delivered Early.

 

[awoohaw]

Try these

FU:

=IF(FS8>0,(N8-FS8),IF(AND(FT8>TODAY(),FT>N8),FT8-N8,FALSE)

NOTE: You don't have an action for when the last IF resolves to FALSE.

FV

=IF(FS8>0,
Choose(SIGN(FS8-N8)+2,"Delivered Early","Delivered On Time","Delivered Late")
Choose(SIGN(FT8-N8)+2,"Delivered Early","Delivered On Time","Delivered Late"))

Book1
	N																																																																																																																																																																	FS	FT	FU
8	2024-02-01																																																																																																																																																																	2024-02-03	Delivered Late	-2
9	2024-02-01																																																																																																																																																																		Delivered Late	-2
10	2024-02-01																																																																																																																																																																	2024-01-31	Delivered Early	1
11	2024-02-01																																																																																																																																																																	2024-02-03	Delivered Late	-2
12	2024-02-01																																																																																																																																																																		Delivered Late	-2
13	2024-02-01																																																																																																																																																																	2024-01-31	Delivered Early	1
14	2024-02-01																																																																																																																																																																	2024-02-03	Delivered Late	-2
15	2024-02-01																																																																																																																																																																		Delivered Late	-2
16	2024-02-01																																																																																																																																																																	2024-01-31	Delivered Early	1
17	2024-02-01																																																																																																																																																																	2024-02-01	Delivered On Time	0
18	2024-02-01																																																																																																																																																																	2024-02-01	Delivered On Time	0
19	2024-02-01																																																																																																																																																																	2024-02-01	Delivered On Time	0
Sheet1

Cell Formulas
Range	Formula
FT8:FT19	FT8	=IF(FS8>0, CHOOSE(SIGN(FS8-N8)+2,"Delivered Early","Delivered On Time","Delivered Late"), CHOOSE(SIGN(FT8-N8)+2,"Delivered Early","Delivered On Time","Delivered Late"))
FU8:FU19	FU8	=IF(FS8>0,N8-FS8,IF(AND(FT8>TODAY(),FT8>N8),FT8-N8))

 

[shiraz50]

Hi .

I changed the method. It works though. Thanks for the help.