Wednesday, March 9, 2016

Home / Unlabelled / IF ELSE Statement in Calculated column

IF ELSE Statement in Calculated column

by on
if(status = "Delined")
then rating = 1
else if(status = "Approved")
then rating = 2
else if(status == "pending")
then rating = 3



=IF([status]="Delined",1,IF([status]="Approved",2,IF([status]="pending",3))) 
You May Also Like:
By at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)