12-04-2018 03:55 PM
12-04-2018 08:20 PMSolution
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
12-05-2018 01:51 AM - edited 12-05-2018 02:06 AM
Thanks so much.
I have another dilemma with the same sheet if you wouldn't mind taking a look?