Forum Discussion
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...
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.
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.