=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