J
Jbaisinger2000
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.
If I insert the word "actual" in for M14 in the formula it will err, ie
"=IF(actual>$G14,+$G14-$E14,0) .. any ideas?
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.
If I insert the word "actual" in for M14 in the formula it will err, ie
"=IF(actual>$G14,+$G14-$E14,0) .. any ideas?