Logical Function excel 2003
IF(G2=327,1,IF(G2=423,2))
with this formula it gives me a result of 1
but when i change G2 to 423 the result remains 1.
how would i correct my formula
thanks for any help
"Jacob Skaria" wrote:
=IF(G2=327,"value if true","value if false")
=IF(G2=327,1,IF(G2=423,2,"both conditions are false"))
In your formula if value is true returns 1
and if false it works on the next condition
IF(G2=423,2,"false")
If this post helps click Yes
---------------
Jacob Skaria
"Denver" wrote:
Hi,
I have this IF function on one of my cell in my excel sheet
IF(G2=327,1,IF(G2=423,2)) - this is my logical test
what would the formula for value_if_true?
thanks for any help
|