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...
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Jun 21, 2021

    DennisMetro 

    Perhaps

    =IF( (C5="")*(D5=""), "",
 IF ( C5>D5,"WALES","DENMARK") )

     

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 21, 2021

DennisMetro 

Perhaps

=IF( (C5="")*(D5=""), "",
 IF ( C5>D5,"WALES","DENMARK") )

 

  • DennisMetro's avatar
    DennisMetro
    Brass Contributor
    Jun 21, 2021
    Thanks Sergei. That works well. Thank you very much. Dennis

Resources