I have written a formula in Excel, but when I press the ENTER key, the formula is still showing but I don't get a value. What gives? How can I get the value that I want? I think that I wrote the formula correctly, but I don't know.
Please be sure
1) Your cell is not in text format
2) This setting is unchecked