[Anonymous]

Hi Friends

I have two columns in the list, X & Y

Need to display the column value based on the below condition 

Condition if the value of x is > 0 then dispaly Y or else display x

how to implement this in the  calculated value ..

provide sample code to achieve this

Thanks

Dhinesh

[Anonymous]

Hello Dhinesh,

Please try to apply the following formula to your calculated column:

=IF([Column_x]>0, [Column_y], [Column_x])

The page (http://msdn.microsoft.com/en-us/library/bb862071.aspx) will provide you more info for Calculated Field Formulas.

Hope this helps,

John

[Author]

Posts