Excel eror or bug ?

New 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 ?



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".
Related Conversations
Round Down to the nearest 5
jshea23 in Excel on
0 Replies
help with formulae
Gavc1 in Excel on
1 Replies
print macro for variable print area
tomb999 in Excel on
0 Replies
Mailing worksheets in excel
Bruno1250 in Excel on
4 Replies
Ribbon or right clicking will not go further out
51218 in Excel on
0 Replies
How to automate a timesheet template?
fishfish31 in Excel on
1 Replies