Hallo

I am trying to use the following IF formula to manage 2 calculations based on a text field condition: if a field contains “furniture” I want the target field to result in a multiplication between a 2 fields, if it says “Fabric” the multiplication uses another field, see below :

IF(Type=“Furniture”,(amount*{Price 1}),(amount*{Price 2}))

but I am getting an error. Is this sintax wrong or am I using the wrong statement ?

Thanks for any help

Regards

Luca