Excel eror or bug ?

Copper Contributor

Dear ,

I am calculating a simple formula in excel but I am getting in error as you can see in the attached screen shot.

 

Please check and advice if it is a bug or not > and how to fix it ?

 

Regards

1 Reply
Cell J6 appears to contain a number, but Excel thinks it is text. Select that cell and Excel should display a small widget (a tiny yellow square with a black exclamation mark in it) next to the cell. Click it and select the option "Convert to number".