Explain about any three error messages in MS Excel.
Answers
Answered by
1
3. Value Error ( #VALUE! ) Excelshows a Value error whenever thevariable mentioned in the formula is wrong. If you see the image below, you will notice that in theformula cell A4 contains text whereas the other 3 cells contain numerical values and hence there is an #VALUE!
Be happy hope it helps u..
Answered by
3
Answer:
####- contents of the cell cannot be displayed correctly as the cell column is too narrow
#REF! - Indicates that a formula contains reference to a cell which is not valid
#DIP/0! - Indicates that a formula is trying to divide a number by zero
Similar questions