Forum Discussion

Victorvlint1's avatar
Victorvlint1
Copper Contributor
Nov 14, 2023

Symbols as a result IF formula excel

Hi

as a result of a simple IF formula =IF(OR(EW1=1;FA1=1);1;0) I get 4 symbols (briefcase, mailbox, briefcase, briefcase) instead of 0 of 1

 

please help me out 

Excel
Formulas and Functions
  • rachel's avatar
    rachel
    Steel Contributor
    Nov 14, 2023
    Would you mind attaching an example spreadsheet? you formula looks straightforward, and I can not picture what might go wrong...
      • rachel's avatar
        rachel
        Steel Contributor
        Nov 14, 2023
        What happens if you change the formula to something like =IF(OR(EW1=1;FA1=1);"Test1";"Test0")?

Share