Forum Discussion
Datevalue+timevalue returns "the cell currently being evaluated contains a constant"
you made a mistake in the function argument separators.
after TEXT(H2 you used ;
in some machines the functions argument separators is either comma or semicolon.
so part of your formula uses comma and part of it semicolon which is not correct.
you can use only one type of separator depending on the regional language setting of your machine.
please see attached file that demonstrates that formula is working.
this issue is caused that whenever value is returned by formula
=IFERROR(DATEVALUE(A3)+TIMEVALUE(A3),TEXT(A3,"General")) excel still detects that as text
so fix this
just put +0 at the end of the formula
like this =IFERROR(DATEVALUE(A3)+TIMEVALUE(A3),TEXT(A3,"General"))+0
Unfortunately this is not working. I have added the "+0" to the I2 column and it returns "#Value". If i add the "+0" to the I3, I4, I5 it is working and again, if i add it to the I6 - not working again.
Any other thoughts on this?
then you should try this formula
=IFERROR(DATEVALUE(A2)+TIMEVALUE(A2),TEXT(A2,"General")+0)
plz see it in attached file.
The same result :( #Value
- is it possible to post a dummy sample workbook?