Spreadsheet Help!

Copper Contributor

Hi There!


Hoping someone might be able to assist.


I am doing up a food costing spreadsheet and am using a pre-designed spreadsheet.  Only some of the formulas are drawing through and I can't see where to adjust it to make the information pull through.


this is the formula - =IFERROR([@[Standard_UnitCost]]/[@[Standard_Qty]],"") and it draws the info through for some of the items but not all.



2 Replies


Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?


You are working with Excel Table, formula is applied to each row of the table with automatic expansion. However, if you enter something else in any cell of this column that won't work.

As @Hans Vogelaar mentioned it's better to discuss with sample file.