I have a large column of prices, however, sometimes the word [FIXED]
also appears in these columns (see screenshot below).
I need to convert this price list to wholesale. All the products wholesale prices are exactly 50% of the retail price. I recently discovered more advanced features in google sheets - even playing with some scripts to accomplish more hefty tasks like this one.
Another issue I have is some prices have a .99 for example: 59.99 retail. The wholesale price for this would be 30.00 however.
Is there something I can do to convert all the prices in a specific column by half? 50% of the original value?
Any help would be much appreciated. I know basic js.
=MID()
or=SUBSTITUTE()
to narrow every item down to a numeric value since your text is always the same. Then simply apply your 50% formula and add the text back if desired.