IHerb speadsheet: Difference between revisions
Jump to navigation
Jump to search
(Created page with "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 O...") |
No edit summary |
||
(8 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
After downloading account history in CSV format, you can convert Current Order Total to numeric value with: | {{DISPLAYTITLE:{{lcfirst:{{PAGENAME}}}}}} | ||
After [https://secure.iherb.com/myaccount/gohr 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) | =IFERROR(ROUND(MID(M2,4,LEN(M2)),2),0) | ||
where M2 is the Current Order Total value cell. | where M2 is the Current Order Total value cell. |
Latest revision as of 22:06, 10 November 2018
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.