Number spread sheet error Archives • McLarenblog

Macintosh Numbers Shows A Formula Error: “Cell Contains A String”

05/14/2016 Score Card

I have for years inserted simple math formulas into Excel with no problem. I had to evaluate three bid proposals for re-piping our house with cooper or PEX. I set up my Mac with Numbers and proceeded to enter data. I suddenly got an error message after entering a rather simple math formula.

The operator “-” expects a number, date, or duration, but cell D3 contains a string.’

The problem was created when the formula used the header cells instead of the data cells.

Cell F2 holding the formula is shown highlighted but the cells that this formula references are actually in the header and not data cells; thus the error message. — The formula in cell F2 references the header cells which does not contain number data but text; thus the error.

In the image above, you can see that while I had selected the cell on the second line to enter the formula, the cells that were part of the formula were actually the header. I really do not know how this happened. As soon as I entered any alpha character (label) into the header, I got a formula error. To solve this problem I made darn sure to enter the formula into the single data cell and not include any header cells as part of the formula.

The image shows top header rows left to right and just below is the data cells. Cell F2 holding the formula is highlighted. That cell then highlights each cell that is part of the formula. — Mac Numbers shows the formula cells are not using header cells.

In the image above, you can see that the formula, when shown on the computer screen, highlights data cells only and no header cells.

I then discovered that I only needed to copy the formula cell, on line 2, that I had just created successfully and paste it down the spread sheet where I wanted the formula to be replicated.