Hi, i need some help with a formula. Can anyone help?

Chrisr

I am trying to get the weight column to automatically tell total weight based on two bits of information entered in to to coil thickness column and Lineal meters column.

The formula would be based on these principles;

If "coil thickness" is 0.4, then weight would equal "lineal meters" x 3.2, but if "coil thickness" is 0.5, then weight would equal "lineal meters" x 4.2.

Is this formula possible?

Any help would be appreciated. Thanks

Peggy Parchert

Hello @Chrisr

Hope you are well. Try this in your Weight column:

=IF([Coil Thickness]@row = 0.5, [Lineal Meters]@row * 4.2, IF([Coil Thickness]@row = 0.4, [Lineal Meters]@row * 3.2))

Peggy