Jun 21 2021 02:45 PM
=IF(C5>D5,"WALES","DENMARK")
so this says insert Wales or Denmark depending on the values in C5 and D5. What do I add so that the output is blank / an empty string if C5 and D5 are empty? Thanks for any help. Dennis
Jun 21 2021 02:49 PM
SolutionJun 21 2021 02:54 PM
Jun 21 2021 02:49 PM
SolutionPerhaps
=IF( (C5="")*(D5=""), "",
IF ( C5>D5,"WALES","DENMARK") )