Excel - Remove #Value error message

December 2016


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));""))) 


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.

Related :

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.