G
Guest
I want to calculate the square foot price using two columns from a database
but the export is as follows:
Width Length Price SQ FT
24 in 82 ft 107 ?
36 in 82 ft 79 ?
60 in 70 ft 350 ?
7 ft 60 ft 220 ?
They column includes the word "in" for Width and "ft" for Length.
Is there a way i could say the following:
Price/(if width contains "in" then divide by 12 and multiple by Length)
I can't figure out how to strip the "in" and "ft" to multiple.
Can someone please help.
thank you,
Pete Petersen
but the export is as follows:
Width Length Price SQ FT
24 in 82 ft 107 ?
36 in 82 ft 79 ?
60 in 70 ft 350 ?
7 ft 60 ft 220 ?
They column includes the word "in" for Width and "ft" for Length.
Is there a way i could say the following:
Price/(if width contains "in" then divide by 12 and multiple by Length)
I can't figure out how to strip the "in" and "ft" to multiple.
Can someone please help.
thank you,
Pete Petersen