How to use Google Docs to extract GE prices ~By Brainymidget in General Guides Posted February 7, 2009 Hello, I tried creating formula for parsing the "m" and "k" prices. The formula would be very big if I would have to merge it with the importhtml formula, so the value loaded from the price list is in D2. =if(iferror(find("m",D2),false),left(D2,find("m",D2)-1)*1000000,if(iferror(find("k",D2),false),left(D2,find("k",D2)-1)*1000,D2)) here is a snapshot: BTW: Thank you for this guide. Really great idea.
How to use Google Docs to extract GE prices ~By Brainymidget
in General Guides
Posted
Hello, I tried creating formula for parsing the "m" and "k" prices.
The formula would be very big if I would have to merge it with the importhtml formula, so the value loaded from the price list is in D2.
here is a snapshot:
BTW: Thank you for this guide. Really great idea.