ISNUMBER FORMULA

[rakesh seebaruth]

Dear Guys

I have the following formula

=IF(ISNUMBER(N7),"Credit Doc Reviewed","Not applicable")

I would like to add the following to the above formula :-

if n7=number then s7= "Credit Doc Reviewed" else if blank "not applicable" if O7= number then S7="Sanction letter Sent to LOB" else "not applicable" If P7 =number then S7="Sanction letter received from LOB" else "not applicable" if Q7= number then S7="Credit Doc release to LOB" else "not applicable" if R7=number then s7="Signature of Document" else not applicable if N7,O7,P7,Q7,R7 = "not applicable" then S7="NOT COMPLIANT -RTS"

Thanks and Regards rakesh

 

[AlanY]

what's S7? when

1) N7 = blank and O7=number
2) N7 = number and O7=number

 

[rakesh seebaruth]

if N7 =blank and O7=number then S7= Sanction letter Sent to LOB

 

[AlanY]

check if this work for you

Book1
	J	K	L	M	N	O	P	Q	R	S
5
6
7	Credit Doc Reviewed				123					Sanction letter received from LOB
8	Sanction letter Sent to LOB
9	Sanction letter received from LOB
10	Credit Doc release to LOB
11	Signature of Document
12
13
Sheet2

Cell Formulas
Range	Formula
S7	S7	=IFERROR(INDEX(J7:J11,MATCH(TRUE,INDEX(ISNUMBER(L7:P7),0),0)),"NOT COMPLIANT -RTS")

 

[rakesh seebaruth]

I have not fully explained to the above to u will check the above formula and will revert thanks

 

[Phuoc]

Try this

Example.xlsx
	N	O	P	Q	R	S	T	U
7	1				1	Credit Doc Reviewed
8		2				Sanction letter received from LOB
9			3			Sanction letter received from LOB
10				4		Credit Doc Reviewed
11					5	Signature of Document
12						NOT COMPLIANT -RTS
13
14
Sheet1

Cell Formulas
Range	Formula
S7:S12	S7	=IF(COUNT(N7,Q7),"Credit Doc Reviewed",IF(COUNT(O7:P7),"Sanction letter received from LOB",IF(COUNT(R7),"Signature of Document","NOT COMPLIANT -RTS")))