Forum Discussion
Solved
Identical Excel formula work on one sheet but no another
Hi I am working on a spreadsheet from my colleague and I would like to use the & function or the CONCAT() function however it is not working on the spreadsheet they left me, however, when I have crea...
- It is fixed now, it is a setting problem, please check the solution here in case anyone needs it.
https://www.excelforum.com/excel-formulas-and-functions/1399559-identical-excel-formula-work-on-one-sheet-but-not-another.html#post5790107
Could it be that you have like an error in cell C9. What happens if you clear that cell, or enter a string?
https://1drv.ms/x/s!ApRAKxWiqaZBhJ5VdLQZ9ltrEU85Hg?e=wMTZn8
The cell C9 is only a number, 1, not any type of calculation
The cell C9 is only a number, 1, not any type of calculation
- I cannot access the file. Is it same result also if you change from C9 to another cell, eg an empty cell that you then enter 1 into?
Normally, it should be that the result in C9 cannot be treated as a string.
The result from the four tests?- It is fixed now, it is a setting problem, please check the solution here in case anyone needs it.
https://www.excelforum.com/excel-formulas-and-functions/1399559-identical-excel-formula-work-on-one-sheet-but-not-another.html#post5790107If that selection is already off and we are still seeing the issue of one workbook's formula works and the other doesn't what other options do we have? formatting, text, etc is all identical yet throws a DIV/0! error and excels solution to this is to use an IF formula but it is an IF formula that is causing this error.
