Forum Discussion

Steel Contributor

Re: Identical Excel formula work on one sheet but no another

Could it be that you have like an error in cell C9. What happens if you clear that cell, or enter a string?

7 Replies

Kay_Engineer
Copper Contributor
Feb 10, 2023
https://1drv.ms/x/s!ApRAKxWiqaZBhJ5VdLQZ9ltrEU85Hg?e=wMTZn8

The cell C9 is only a number, 1, not any type of calculation
- bosinander
  Steel Contributor
  Feb 10, 2023
  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?
  - Kay_Engineer
    Copper Contributor
    Feb 10, 2023
    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