Forum Discussion

CottageCelebrations's avatar
CottageCelebrations
Copper Contributor
Apr 16, 2021
Solved

IF Function

I am trying to create a function to calculate the number of each cake flavor needed. This is what I was trying to input into P2 but got a NAME error: =IF(J2=”Vanilla”,L2,"") I was als...
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Apr 16, 2021

CottageCelebrations 

In P2:

 

=IF($J2=P$1,$L2,"")

 

If you use comma as decimal separator, it should be

 

=IF($J2=P$1$L2;"")

 

Fill down, then to the right (or vice versa).

  • CottageCelebrations's avatar
    CottageCelebrations
    Copper Contributor
    Apr 16, 2021

    Thanks, I tried yours too and the first one worked but the second formula filled the cell with the formula, not the number.  I tried formatting the cell as a number and checking the box with the comma but didn't help.

     

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Apr 17, 2021

      CottageCelebrations 

      As a comment, based on screenshot only, especially if it doesn't show what is in formula bar, quit often it's hard to understand what is the actual reason of the error. On this site we may only make some guesses. Hans indicated two possible reasons - wrong quotes and in your locale you shall use semicolons instead of commas. One of them works.

      Bottom line - it's always better to provide small sample file which illustrates an issue. Answers will be more exact and received more fast.