set the formula

[Mohammed Gheewala]

38110

1

OT

GIS

Closed

25.Jan.18

25.Jan.18

20.Feb.18

B

17.Mar.18

C

Closed

(Please help me in setting the formula : column K1 if Appears "C" Than I need to show Column L1 as Pending)

38111

1

OT

GIS

Closed

25.Jan.18

25.Jan.18

27.Feb.18

B

Closed

[#2]

Hi Gheewala.

You can use in L1

=IF(K1="C","Pending,"")

[#3]

=IF(K1="C","Pending","")