Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Symbols as a result IF formula excel

Copper Contributor

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 

3 Replies
Would you mind attaching an example spreadsheet? you formula looks straightforward, and I can not picture what might go wrong...

@rachel 

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

 

Schermafbeelding 2023-11-14 175249.png

What happens if you change the formula to something like =IF(OR(EW1=1;FA1=1);"Test1";"Test0")?