I am able to get this formula to work on a single cell, but wish for it to work on a range of cells. When I use a range I get the Value error, I would be grateful if anyone knows what I could do to rectify this. I want a single cell to show R = Redacted Call whenever the letter R is placed within the range of G6:G203.
=IF(G6="R", "R = Redacted Call", "") This works, but I need it to work on a range and not a single cell.
=IF(G6:G203="R", "R = Redacted Call", "") Returns the value error
Any help would be most appreciated.