HAVE TRIED IT IN SEVERAL AREAS AND HAVE IT WORKING THANKS TO YOUR GUIDANCE
CELL REFERENCES ARE DIFFEENT DUE TO SHEET MOD BUT HERE IS WHAT WORKS:
=IF(D24="","117 WINNER",IF(D24="L",C25,IF(D24="W",C24)))
Many thanks for your assistance - as a novice user I had spent many hours trying this and...
Trying to get syntax right without luck here is what I am trying to do
-formula in G16 to check contents of C7
- if contents of C7 = " " G16="111 Winner"
- if contents of C7 ="L" G16 = C6 This is text
- if contents of C7 ="W" g16 = C7 this is also text
(formula would be modified...