I have a CSV file that I want to adjust pricing. How would I add 25% to the price column. It has 1700 products on it so doing it by hand would take to long.
The column looks like this:
Price 0 69.9875 169.9875 [FIXED]69.9875 [FIXED]169.9875
update:
No just 25% off to the [FIXED] Items
=ARRAYFORMULA(IF(REGEXMATCH(A2:A&"", "(\[. \])\d (?:.\d )?"),
IFERROR(IFERROR(REGEXEXTRACT(A2:A&"", "(\[. \])\d (?:.\d )?"))&
(REGEXEXTRACT(A2:A&"", "\d (?:.\d )?")
REGEXEXTRACT(A2:A&"", "\d (?:.\d )?")*0.25)), A2:A))