Forum Discussion
Formula red dotted lines around cell.
Three observations:
1) The numbers in column AD are left aligned, so these are probably texts. Can't really see if you used a comma or a point as the decimal separator. Formatting a text as a number will not resolve the issue. You need to enter the numbers in the correct local format.
2) And if that local format expects a decimal point, then the separator to be used between the arguments in a formula needs to be a comma. If the decimal is marked with a comma, you need to use semi-colons in the formulas stead. The red dotted line indicated that you have used the wrong separator.
3) When I copy your first formula to an Excel sheet in the on-line version I get italic quotation marks and a NAME error. When, I replace them with regular quotation marks and correct the numbers (see 1 above), the function works. Not correcting the numbers will always return Large, so you really need to fix that first. My set-up expects comma as the list separator, so no problem there. No red dots around the cell.
mr_T665 Please have a look at the attached file and compare the quote marks with yours.
