Forum Discussion

Victorvlint1's avatar
Victorvlint1
Copper Contributor
Nov 13, 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
Iron Contributor
Nov 13, 2023
Would you mind attaching an example spreadsheet? you formula looks straightforward, and I can not picture what might go wrong...
Victorvlint1's avatar
Victorvlint1
Copper Contributor
Nov 13, 2023

rachel 

ALS = IF // OF = OR (dutch excel version)

 

  • rachel's avatar
    rachel
    Iron Contributor
    Nov 14, 2023
    What happens if you change the formula to something like =IF(OR(EW1=1;FA1=1);"Test1";"Test0")?

Resources