Limit the data in one column by matching 2 cloumns

[Tushar Patel]

I have table like this. And I want to change the values in column C like this: If ColumnA = Column B then Column C = "[Column C]/2" . How can I do this

 

 

Column A Column B Column C

 

 

 

 

 

 

 

A A 100

B A 50

 

 

 

 

 

 

 

C C 80

[Richard Pobi]

If([Column A]="A",If([Column B]="A",0,[Column C] / 2),0)