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

mar1kor2_0-1704396808941.png

mar1kor2_1-1704396834780.png

 

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.