Skip to main content

Hello community!

I have a column with 3 simple choices "number of trucks" and I wants to convert these choices into figures in a "quantity" column. 

IF({number of trucks} = "3 trucks of more", "0", )
IF({number of trucks} = "1 truck (24 tons)", "24",)
IF({number of trucks} = "2 trucks (48 tons)", "48",)

I can't close my formula, do you have an idea?

Try:

IF({number of trucks} = "3 trucks of more", "0") & IF({number of trucks} = "1 truck (24 tons)", "24") & IF({number of trucks} = "2 trucks (48 tons)", "48")

You could also use a SWITCH() instead:

SWITCH( {number of trucks}, "3 trucks of more", "0", "1 truck (24 tons)", "24", "2 trucks (48 tons)", "48" )

 

Terms & ConditionsAccessibility statement