Forum Discussion

DennisMetro's avatar
DennisMetro
Brass Contributor
Jun 21, 2021
Solved

Excel code for IF function in Office 365

=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

Resources