Thanks...I have a database with (for simplicity's sake):
Column A - total costs (Costs)
Column B - worked days (Days)
Obviously a1/b1 gives me the cost per day
However, in order to drive everything from a single formula, I want to use a named formula instead, with the database as an Excel Table.
The formula converts to @[Costs]/@[Days] - which is fine as a standard formula. However, if I then attempt to use this formula, with an error check for division by zero as a named formula (paste iferror(@[Costs]/@[Days],0) into a range name called CPD, I get the error message "The name that you entered is not valid".
Doing it as iferror(a2/b2,0) works fine.
What's the problem with the structured references ?
Thanks
Mick the Horse