One way:

=IF(ISNUMBER(M14),IF(M14$G14,$G14-$E14,0),"#VALUE!")

or, if you want an actual #VALUE! error:

=IF(ISNUMBER(M14),IF(M14$G14,$G14-$E14,0),1+"A")



In article ,
Jbaisinger2000 wrote:

I have the following formula "=IF(M14$G14,+$G14-$E14,0)".
Yet when I put "actual" or some text in m14, I receive the TRUE arguement
(+$G14-$E14) and gives me a value...I was hoping for #VALUE instead. Any
ideas when the arugement is recognizes the text as a numeric value.