Forum Discussion

Copper Contributor

Dec 04, 2018

Solved

Formula not calculating

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.

HELPSAMPLE.xlsx11 KB

excel

Formulas and Functions

Haytham Amairah
Dec 05, 2018
Hi Melissa,

The reason is that these cells are in text format!

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

Haytham Amairah

Silver Contributor

Dec 05, 2018

Hi Melissa,

The reason is that these cells are in text format!

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

Melissa McDowell

Copper Contributor

Dec 05, 2018

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#M22522

Haytham Amairah
Silver Contributor
Dec 05, 2018
Okay, I have replied to that post.