Forum Discussion
Spill Error with IF function
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.
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.
.png){kind=link}