Post: #1
మనం వాడే Excel Software లో ఈ క్రింది ఎర్రర్స్ వస్తే జాగ్రత్తగా చూసి సరిచేయండి. మనం వ్యావహారికంలో ఎక్సెల్ సాఫ్ట్ వేర్ లో ఎక్కడ తప్పు చేశామో...వాటి అర్ధాలు ఏమిటో తెలుసుకోండి.

If a formula is incorrectly entered in an Excel Work sheet, an error message in displayed.
Below is a list of error messages and their meanings :

Quote:Error Message : Error Meaning
# DIV/0! = The formula contains a blank cell, which Excel considers to be 0 value (OR) The formula attempts to divide by ZERO.

# NAME ? = There is an invalid function name or cell reference in the formula - for example, summ instead of sum. (OR) The formula contains text that Excel doesn't recognize (such as an unknown named range).

# Value = The formula refers to a cell that contains data, such as text, that cannot be used in a formula. (OR) The formula has the wrong type of argument (such as text where a TRUE or FALSE value is required).

##### = The column is not wide enough to display the results of the calculation.

# REF = The formula refers to a cell tyhat is not valid, such as a cell that was deleted. (OR) The formula refers to a cell that doesn't exist (which can happen whenever cells are deleted)

Quote this message in a replyReply

Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)