+6Hello 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?
+31Try:
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"
)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.