Hello,
I'm trying to calculate the product =100*A3 , but I get the #VALUE error. What's more, I'm getting this error in all cells in which I'm trying to do some sort of mathematical operation. I have tried setting the cells to number value mode, as well as using =PRODUCT(100,A3) (in fact, I'm using Excel in Spanish, so it would be: =PRODUCTO(100,A3) ). Besides, the error is not due to having a space before the value, either. The most weird thing is that this problem just happens in two of the four sheets of my Excel file. That's why I have also tried checking whether the cell format is different in each sheet, but it appears to be the same in all of them.
Moreover, although I have checked some websites regarding this issue, I feel they don't have the answer to my problem. Here are some of the links I have had a look at (the others are in Spanish, so I don't think it's worth posting them here):
https://support.office.com/en-us/ar...UE-error-15e1b616-fbf2-4147-9c0b-0a11a20e409e
http://www.mrexcel.com/forum/excel-...ved-linked-cells-when-data-source-closed.html
http://www.mrexcel.com/forum/excel-questions/510783-troubleshooting-sumproduct-value-error.html
Resolving #VALUE! Errors in Microsoft Excel | AccountingWEB
By the way, I'm using Microsoft Excel 2010 Professional. I'm not an expert on Excel, as I have only used to do some basic calculations, so it's quite possible this problem is easy to solve. There might be an answer to my problem somewhere on the Internet, but I haven't been able to find anything. Please tell me if it's necessary to add anything else to the post.
Thank you very much for your attention and sorry for the inconvenience
Happy New Year's Eve/ New Year to everyone on the forums!
I'm trying to calculate the product =100*A3 , but I get the #VALUE error. What's more, I'm getting this error in all cells in which I'm trying to do some sort of mathematical operation. I have tried setting the cells to number value mode, as well as using =PRODUCT(100,A3) (in fact, I'm using Excel in Spanish, so it would be: =PRODUCTO(100,A3) ). Besides, the error is not due to having a space before the value, either. The most weird thing is that this problem just happens in two of the four sheets of my Excel file. That's why I have also tried checking whether the cell format is different in each sheet, but it appears to be the same in all of them.
Moreover, although I have checked some websites regarding this issue, I feel they don't have the answer to my problem. Here are some of the links I have had a look at (the others are in Spanish, so I don't think it's worth posting them here):
https://support.office.com/en-us/ar...UE-error-15e1b616-fbf2-4147-9c0b-0a11a20e409e
http://www.mrexcel.com/forum/excel-...ved-linked-cells-when-data-source-closed.html
http://www.mrexcel.com/forum/excel-questions/510783-troubleshooting-sumproduct-value-error.html
Resolving #VALUE! Errors in Microsoft Excel | AccountingWEB
By the way, I'm using Microsoft Excel 2010 Professional. I'm not an expert on Excel, as I have only used to do some basic calculations, so it's quite possible this problem is easy to solve. There might be an answer to my problem somewhere on the Internet, but I haven't been able to find anything. Please tell me if it's necessary to add anything else to the post.
Thank you very much for your attention and sorry for the inconvenience
Happy New Year's Eve/ New Year to everyone on the forums!