Ask a question »

Excel - Remove #Value error message

September 2015


[Excel] Remove #Value error message



Issue


How to remove the #Value error while leaving the formula in cell?
The formula is:
  • =IF(AND(C5>D5);((A3*A4)-(12,5));IF(AND(D5>C5);((C4*C3)-(12,5));IF(AND(C5=D5);((B4*B3)-(12,5));""))) 

Solution


Try this:
  • =IF(C5>D5;(A3*A4)-12,5;IF(D5>C5;(C4*C3)-12,5;IF(C5=D5;(B4*B3)-12,5;""))) 


Then the error message "# Value!" is caused by a text input or space in your cell calculation. It's better avoid this kind of data entry.

Thanks to Mike-31 for this tip.
For unlimited offline reading, you can download this article for free in PDF format:
Excel-remove-value-error-message.pdf

See also

In the same category

Published by aakai1056.
This document entitled « Excel - Remove #Value error message » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.