confused:
In the attached spreadsheet the formula in cell I12 is returning #Value!. I evaluated the formula. Cell G12 evaluates as " 13". The quotes don't make sense to me. See picture for the evaluation. wrong data type error.JPG:
G12 format is General number.
I changed it to Number 0 decimal places, but the error remained.
I cleared the format, but the error remaianed.
I retyped the formula, but the error remained.
I copied the formula from a row in another row of the spreadsheet that "worked", but the error remained.
I am stumped. What might resolve this?
Catherine
Bookmarks