Multi field formula to update values for certain records

[monish_chandra]

I'm trying to inflate the values by a % for certain records in the data. I'm trying to do this using the Multi-Field formula. But The values are 

ID	Modifier	Payor1	Payor2	Payor3
1	51	347	3466	523
2		5457	3474	3468
3	54	589	800	790

I need to inflate the values by 150% for Payor1,2 and 3 if the modifier is 51 and by 120% for Modifier 54 ELSE No change to the values. In the above example rows with ID 1 and 3 have to be inflated. I tried this below formula but its not correct. 

IF [Modifier]=51 THEN [Payor1]=[Payor1]*1.5 ELSE 0 AND [Payor2]=[Payor2]*1.5 AND [Payor3]=[Payor3]*1.5

ELSEIF  [Modifier]=54 THEN [Payor1]=[Payor1]*1.2 ELSE 0 AND [Payor2]=[Payor2]*1.2 AND [Payor3]=[Payor3]*1.2

ENDIF

[christine_assaad · Accepted solution]

Hi @monish_chandra 

Is this what you are looking for? Cheers!