Forum Discussion
DennisMetro
Jun 21, 2021Brass Contributor
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
3 Replies
- SergeiBaklanDiamond Contributor
- DennisMetroBrass ContributorThanks Sergei. That works well. Thank you very much. Dennis
- SergeiBaklanDiamond Contributor
DennisMetro , you are welcome