Forum Discussion
Spill Error with named ranges on a table
Hey,
I have a table and when i enter =Hours*Rate it returns a #SPILL! but if i enter the same outside the table i get the result, i know i can enter =[@Hours]*[@Rate] in the table but i just want to know if will this affect the actual mos expert exam as in the tutorial they are getting the result with =Hours*Rate.
It depends on concrete situation - are Hours and Rate named ranges or columns within the table or, as variant, named cells. In any case you cant use formula which return the spill within the table, only outside it and if there is enough space for the spill. Within the table second formula is correct, it returns result for the current row.
SergeiBaklan Hours and Rate are named ranges
If named ranges when you shall use =Hours*Rate outside the table.
