iHerb speadsheet

From John's wiki

Revision as of 22:06, 10 November 2018 by Sixsigma (talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to 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.

Retrieved from "https://www.jj5.net/wiki/mediawiki/index.php?title=IHerb_speadsheet&oldid=3458"