Here is the formula:
=IF($Games.$J$92="","",IF($Games.$J$92=$Games.$L$92,“T”,IF($Games.$J$92>$Games.$L$92,“W”,“L”)))
I want to change all the 92 to 103.
Select all the cells that contain 92, then press Ctrl-h to call the Find and Replace window and type the information:
Note that I searched for $92 instead of 92 but it doesn’t matter in this case.
If I just select one cell it didn’t work for me.
If I selected the cell I wanted to change and the blank cell next to it. That worked for me.