You can see how I've done it on my Farming sheet here, bottom left.
So far my spreadsheet for farming is coming along great, however, I'm having the issue that googledocs likes to return things back with letters (ie. lantadyme seed, comes back as 32.1k, rather than 32100), which makes them unusable in calculations.
How can I make it so googledocs understands "k" to mean "1000"?
EDIT: my problem is the same as Ickdeep's.
EDIT: or even better
=if(iferror(find("m",B21),false),left(B21,find("m",B21)-1)*1000000,if(iferror(find("k",B21),false),left(B21,find("k",B21)-1)*1000,B21))where "B21" is the import cell.
Edited by Kaphias, 13 June 2010 - 08:19 PM.