Hello - I am pretty sure the answer I'm looking for is here somewhere, but I'm not seeing it. Any help is greatly appreciated. I'm working on a softball pitching chart & trying to return results of balls (G5) & strikes (H5) where only one cell will have data. Specific text is "*H" for items in my dropdown list where the pitcher "hits" her spot (F5). So something like this:
Formula in Cell F5: IF G5 or H5 ="*H", return "Y" to cell F5, otherwise "" (leave blank or return "N").
I'm sure it's something simple - I keep getting "too many arguments," "FALSE," "VALUE," or "N" I'm attaching a screenshot that might be helpful.
Thank you in advance for any assistance you can provide.
Formula in Cell F5: IF G5 or H5 ="*H", return "Y" to cell F5, otherwise "" (leave blank or return "N").
I'm sure it's something simple - I keep getting "too many arguments," "FALSE," "VALUE," or "N" I'm attaching a screenshot that might be helpful.
Thank you in advance for any assistance you can provide.