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

=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

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

=IF(G2=327,1,IF(G2=423,2))

The above formula should return 1 for 327 and 2 for 423. Try this in a fresh
workbook. Your current cell may be having some formatting. Check whether
there are any decimals formatted (not to display)...like 423.01 or so....

If this post helps click Yes
---------------
Jacob Skaria


"Denver" wrote:

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

Hi,

I don't think non-displaying decimals could change 423 into 327.

The problem you are describing would be a bug if it were try. Feel free to
send me a copy of the offending workbook and I will take a look. combine the
three last three lines of my salutation.
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire
shanedevenshire.
@sbcglobal
..net


"Denver" wrote:

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