Forum Discussion
Excel Formula error
Hello, I have been trying to implement the following formula without success, Thanks a lot for your help !
Which formula?
Sorry, it was in my screenshot only, here it is
=IF(AB7=AE7*AC7;"N/A";AB7-AE7*AC7)
Also tried
=IF(AB7=AE7*AC7,"N/A",AB7-AE7*AC7)
- Can you paste a portion of the table or sample data to test with, as I'm not seeing any issues with your formula. Testing in a blank workbook I was able to write it out in the same format and it worked fine.
=IF(B3=E3*C3,"N/A",B3-E3*C3)
Sample data with more detail of what you're trying to get as your outcome could help to identify if there is something else going on, but overall your syntax appears correct and the error you posted seems to be the general "This isn't a formula" error, but I also don't speak french so can't read the full error.Dustin-Doucette Hello,
Thanks a lot for your time;
I finally solved my problem,
I was in a french version of Excel and Formula as to be =SI instead of =IF,
Best Regards,
