if(response=SUCCESSOK,24,0) ... if(response=SUCCESSOK,24,if(response=NotBehind,10,0))

if(response=SUCCESSOK,24,0) ... if(response=SUCCESSOK,24,if(response=NotBehind,10,0))

I want to add a formula column that assigns a numeric (currency) value based on a string of text in another column.

I have a column named response with the following possible values: SUCCESSOK; FAILED - 1,-1,24 = -1; FAILED - DUPLICATE; FAILED - Requirement; FAILED - VULGAR; NotBehind.

I would like to add a formula column named revenue that assigns a revenue value based on the response value (for example: SUCCESSOK=24, FAILED - DUPLICATE=0).

Is there a way to do this with Zoho DB & Reports?

Thank you!