Forum Discussion

Don_Pepe's avatar
Don_Pepe
Copper Contributor
May 12, 2023
Solved

#VALUE disappears when I delete a random cell or line

Hi,    Sometimes when I open my file, it's full of "#VALUE" and nothing seems wrong.  I tried to recalculate and recalculate manually but doesn't work.    I found out that if I delete a random c...
excel
Formulas and Functions
  • Don_Pepe's avatar
    Don_Pepe
    May 17, 2023
    Hi NikolinoDE,

    Thanks for your help, I found the issue.
    DATEVAL and TEMPSVAL (DATEVALUE & TIMEVALUE in en) induce regional formating error in Excel online.
    I just remove them and now everything is ok.

    Thanks again for your help,

    Don
NikolinoDE's avatar
NikolinoDE
Gold Contributor
May 12, 2023
The updated formula you provided looks correct to me.
There shouldn't be any errors in this formula, as long as the cell references (AX$4 and $B6) are valid and the data in those cells are correctly formatted as dates and times.
One thing to note is that the results of this formula may depend on the regional settings of your computer. The date and time formats used in the formula (i.e. "jj/mm/aaaa" and "hh:mm:ss") may need to be adjusted based on the regional settings of your computer to ensure that the formula returns the correct values.
If you continue to experience issues with this formula, please provide more information on the specific error message you are seeing.


I hope this helps!
Don_Pepe's avatar
Don_Pepe
Copper Contributor
May 17, 2023
Hi NikolinoDE,

Thanks for your help, I found the issue.
DATEVAL and TEMPSVAL (DATEVALUE & TIMEVALUE in en) induce regional formating error in Excel online.
I just remove them and now everything is ok.

Thanks again for your help,

Don

Resources