Home

Excel Formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-683179%22%20slang%3D%22en-US%22%3EExcel%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-683179%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20written%20a%20formula%20in%20Excel%2C%20but%20when%20I%20press%20the%20ENTER%20key%2C%20the%20formula%20is%20still%20showing%20but%20I%20don't%20get%20a%20value.%20What%20gives%3F%20How%20can%20I%20get%20the%20value%20that%20I%20want%3F%20I%20think%20that%20I%20wrote%20the%20formula%20correctly%2C%20but%20I%20don't%20know.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-683179%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-683636%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-683636%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F358206%22%20target%3D%22_blank%22%3E%40Betsey-2124%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20be%20sure%3C%2FP%3E%0A%3CP%3E1)%20Your%20cell%20is%20not%20in%20text%20format%3C%2FP%3E%0A%3CP%3E2)%20This%20setting%20is%20unchecked%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20700px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117787iBA1BCF0E5CE62929%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Betsey-2124
Visitor

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.

1 Reply

@Betsey-2124 

 

Please be sure

1) Your cell is not in text format

2) This setting is unchecked

image.png

 

Related Conversations