Need Multiple IF AND Formula Help

[cpbrehmer]

I am trying to use a Formula to find values in two columns and return different results based on those values. Is that possible and can someone assist? I have the first IF AND working but don't know how to add additional values.

Ex - 

IF Contains([Field1],"Value1") && Contains([Field2],"ValueX")

THEN .10

IF Contains([Field1],"Value2") && Contains([Field2],"ValueY")

THEN .20

[MarqueeCrew · Accepted solution]

IF
Contains([field1],"Value1") && Contains([field2],"ValueX")
THEN '.10'
ELSEIF
Contains([field1],"Value2") && Contains([field2],"ValueY")
THEN '.10'
ELSE
'.99'
ENDIF

That should do it for you :)

Happy Easter,

Mark