iHerb speadsheet

From Sixsigma
Jump to: navigation, search

After downloading account history in CSV format, you can convert Current Order Total to numeric value with:

=IFERROR(ROUND(MID(M2,4,LEN(M2)),2),0)

where M2 is the Current Order Total value cell.