IF Function Question

[rhermogeno]

The syntax =IF(logical_test, value_if_true, value_if_false) for the IF Function would initially display the False value. I want it to not display anything yet. It should wait for the logical test to be evaluated first before it displays anything. So in short, I just need the cell containing the IF function to display a blank first prior to logical evaluation.

* Yes there is a FALSE value to be evaluated so if anyone says just put " " then it will not be viable.

Thanks in advance guys!

[bebo021999]

Let says A1 & A2 contains value then you want to test or do not test whether A1=A2 or not
A1=100
A2=200
A3 will be either "test" or "not test". If A3="test", then test A1&A2, if "not test", leave blank.

=IF(A3="test",IF(A1=A2,value_if_true,value_if_false),"")

[rhermogeno]

Let says A1 & A2 contains value then you want to test or do not test whether A1=A2 or not
A1=100
A2=200
A3 will be either "test" or "not test". If A3="test", then test A1&A2, if "not test", leave blank.

=IF(A3="test",IF(A1=A2,value_if_true,value_if_false),"")

Hey it works! Thanks a lot!