Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Greater than less than arguement returning value when text inputte
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Greater than less than arguement returning value when text inputte
Text is always greater than numericals according to Excel, you can fix that
by using this instead =IF(AND(ISNUMBER(M14),M14$G14),$G14-$E14,0) note that there is no need of the plus sign in front of G14 in your formula -- Regards, Peo Sjoblom "Jbaisinger2000" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Greater than less than arguement returning value when text inputte
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic arguement? | Excel Worksheet Functions | |||
increasing an arguement | Excel Worksheet Functions | |||
Two VLookups in one arguement | Excel Worksheet Functions | |||
RIGHT Arguement? | Excel Discussion (Misc queries) | |||
More than 7 IF statements in one arguement | Excel Worksheet Functions |