Formula that stays in a cell
Solved
MLC29
Posted messages
2
Status
Member
-
MLC29 Posted messages 2 Status Member -
MLC29 Posted messages 2 Status Member -
Hello,
I am working with CALC on Windows 10. I use the VLOOKUP function, and I am almost certain there is no error in the formula; however, the formula does not execute and remains written in the cell.
This also happened to me in Excel, but there was a trick I can't quite remember (tools, ??)
Do you have a solution, and do you know why this is happening?
Thank you for your help.
Configuration: Windows / Firefox 60.0
I am working with CALC on Windows 10. I use the VLOOKUP function, and I am almost certain there is no error in the formula; however, the formula does not execute and remains written in the cell.
This also happened to me in Excel, but there was a trick I can't quite remember (tools, ??)
Do you have a solution, and do you know why this is happening?
Thank you for your help.
Configuration: Windows / Firefox 60.0
2 answers
Good evening,
simply because your cells are formatted as text, so select your range of cells and reformat your range to standard or number,
the formulas will remain written, you will need to double click on each cell and press Enter for them to take the numeric format again
See you later
Mike-31
I am responsible for what I say, not for what you understand...
simply because your cells are formatted as text, so select your range of cells and reformat your range to standard or number,
the formulas will remain written, you will need to double click on each cell and press Enter for them to take the numeric format again
See you later
Mike-31
I am responsible for what I say, not for what you understand...