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

getting a function error for no reason(?)

Copper Contributor




Please help. I even tried =IF(C2>C14,1,0) but I get the same, however function AVERAGE works normally

1 Reply

@mar1kor2  .... Have you tried


=IF(C2>C14; 1; 0)


That is, semicolon separators instead of commas.