Home > Mobile >  Adding 25% to Column in Excel
Adding 25% to Column in Excel

Time:08-04

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

enter image description here


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))

enter image description here

demo sheet

  • Related