SOLVED
Home

Formula not calculating

%3CLINGO-SUB%20id%3D%22lingo-sub-295003%22%20slang%3D%22en-US%22%3EFormula%20not%20calculating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-295003%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20trouble%20making%20my%20formula%20calculate%20-%20when%20I%20press%20enter%20it%20just%20moves%20to%20the%20next%20cell%20without%20coming%20up%20with%20a%20result.%20I%20have%20attached%20a%20sample.%20It%20is%20in%20Column%20I.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-295003%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-295427%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20not%20calculating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-295427%22%20slang%3D%22en-US%22%3E%3CP%3EOkay%2C%20I%20have%20replied%20to%20that%20post.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-295230%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20not%20calculating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-295230%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20so%20much.%3C%2FP%3E%3CP%3E%26nbsp%3BI%20have%20another%20dilemma%20with%20the%20same%20sheet%20if%20you%20wouldn't%20mind%20taking%20a%20look%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FCalculating-selling-price-including-profit%2Fm-p%2F295231%23M22522%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FCalculating-selling-price-including-profit%2Fm-p%2F295231%23M22522%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-295099%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20not%20calculating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-295099%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Melissa%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EThe%20reason%20is%20that%20these%20cells%20are%20in%20text%20format!%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F61405i509167AE29CE925D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Text%20Format.png%22%20title%3D%22Text%20Format.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%2C%20change%20the%20format%20to%20General%20or%20Number%2C%20then%20enter%20the%20formula%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20note%20that%20the%20formulas%20in%20columns%20Q%2C%20O%2C%20N%2C%20and%20F%20are%20also%20in%20Text%20format!%3C%2FP%3E%3CP%3ESo%20you%20have%20to%20convert%20them%20as%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EPlease%20note%20that%20if%20you%20have%20a%20formula%20in%20a%20cell%2C%20and%20this%20formula%20refers%20to%20a%20cell%20formatted%20in%20text%2C%20this%20cell%20will%20become%20infected%20and%20will%20become%20like%20the%20format%20of%20the%20cell%20to%20which%20the%20formula%20refers%3CSPAN%3E!%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EHope%20that%20makes%20sense%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Melissa McDowell
Occasional Contributor

I am having trouble making my formula calculate - when I press enter it just moves to the next cell without coming up with a result. I have attached a sample. It is in Column I.

 

 

3 Replies
Solution

Hi Melissa,

 

The reason is that these cells are in text format!

Text Format.png

 

So, change the format to General or Number, then enter the formula again.

 

Please note that the formulas in columns Q, O, N, and F are also in Text format!

So you have to convert them as well.

 

Please note that if you have a formula in a cell, and this formula refers to a cell formatted in text, this cell will become infected and will become like the format of the cell to which the formula refers!

 

Hope that makes sense

Thanks so much.

 I have another dilemma with the same sheet if you wouldn't mind taking a look?

 

https://techcommunity.microsoft.com/t5/Excel/Calculating-selling-price-including-profit/m-p/295231#M...

Okay, I have replied to that post.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies