May occur for Optimising with the CELL function or the User defined tables editor
(1) The cell format is not correct.
For example if using the table:-
##DOOR,500,600,800
OAK,12.99,15.50,17.90
GREY,9.00,12.00,15.00
TEAK,11.50,12.50,13.50
The following cell formula produces this error.
=CELL(DOOR,500,GREY,600,OAK)
Only one value can be selected in a cell function
=CELL(DOOR,500,GREY)
=CELL(DOOR,600,OAK)
(2) The cell contents do not match the format specified in cell editor
In the User defined tables editor the cell format (text, boolean, number etc.) is set when the table is created. The Cell contents must match the format.
- Check the formula and / or the cell contents
|
33097 |