Forum Discussion
set the formula
| 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 | |||||||||||||
Hi Gheewala.
You can use in L1
=IF(K1="C","Pending,"")
- =IF(K1="C","Pending","")
