Forum Discussion
Spill Error with IF function
I am working on a school excel project and I keep getting the spill error. I have included a screenshot of my excel spreadsheet. Would anyone be able to help me with this?
My book is telling me to type =if ( d9="Warranty",0,[Time Billed] * 75)
Obviously, you are learning about structured table references. Then this is the formula you need.
=IF([@[Service Type]]="Warranty",0,[@[Time Billed]]*75)May be a bit confusing in the beginning with the "@"-signs and the square brackets, but if you build the formula by pointing at the cell within the table, it will automatically become like that. The "@"-sign tills it to only look at the cell on the current row. Of course, you can leave the "D9" reference in place, but then you might as well use "E9" for the time billed part of the formula.
3 Replies
Obviously, you are learning about structured table references. Then this is the formula you need.
=IF([@[Service Type]]="Warranty",0,[@[Time Billed]]*75)May be a bit confusing in the beginning with the "@"-signs and the square brackets, but if you build the formula by pointing at the cell within the table, it will automatically become like that. The "@"-sign tills it to only look at the cell on the current row. Of course, you can leave the "D9" reference in place, but then you might as well use "E9" for the time billed part of the formula.
- Thank you beyond words! 10/2021.
.png){kind=link}