Forum Discussion

ChidiV's avatar
ChidiV
Copper Contributor
Oct 28, 2021
Solved

#SPILL

Hi Everyone,   I have this formula =IF([Article Base Code] ="RD*","DAIRY",IF([Article Base Code] ="CS*","PIGS"))    I am getting #SPILL ERROR   Please help        
excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Oct 29, 2021

    ChidiV Wait!! YOu can't use the wild card match that way in an IF function.

     

    Try it this way:

     

    =IF(COUNTIF([@Article Base Code],"RD*"),"DAIRY",IF(COUNTIF([@Article Base Code],"CS*"),"PIGS")) 

     

ChidiV's avatar
ChidiV
Copper Contributor
Oct 29, 2021
I'll share the file cause im at frustration level
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Oct 29, 2021

ChidiV Wait!! YOu can't use the wild card match that way in an IF function.

 

Try it this way:

 

=IF(COUNTIF([@Article Base Code],"RD*"),"DAIRY",IF(COUNTIF([@Article Base Code],"CS*"),"PIGS")) 

 

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Oct 29, 2021

    ChidiV Great! Should have thought about that from the start 🙂

  • ChidiV's avatar
    ChidiV
    Copper Contributor
    Oct 29, 2021
    COUNTIF works well 👍

Resources