Forum Discussion

MaximDavid's avatar
MaximDavid
Copper Contributor
Jun 03, 2020

Excel Formula error

Hello,

I have been trying to implement the following formula without success, 

 

Thanks a lot for your help !

 

excel
Formulas and Functions

4 Replies

    • MaximDavid's avatar
      MaximDavid
      Copper Contributor
      Jun 03, 2020

      peteryac60 

      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)

      • Dustin-Doucette's avatar
        Dustin-Doucette
        Brass Contributor
        Jun 03, 2020
        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.

Resources