AgingMiser Posted July 26, 2009 Share Posted July 26, 2009 Got it. =IF(Isnumber(http://itemdb-rs.runescape.com/results.ws?query=%22[item]%22), http://itemdb-rs.runescape.com/results.ws?query=%22[item]%22,MID(http://itemdb-rs.runescape.com/results.ws?query=%22[item]%22,2,9)) Alternatively, if the price change is defined in [cell], you can use =IF(Isnumber([cell]), [cell],MID([cell],2,9)) Link to comment Share on other sites More sharing options...
GreenFire63 Posted July 27, 2009 Share Posted July 27, 2009 I tried your second suggestion on that, after typing in: =IF(Isnumber([D4]), [D4],MID([D4],2,9)) I got an error message and when I double clicked on the cell, this showed up.... =IF(Isnumber([R[-1]C[-5]]), [R[-1]C[-5]],MID([R[-1]C[-5]],2,9)) Any ideas? Billionaire status as of 7/19/2009 Link to comment Share on other sites More sharing options...
AgingMiser Posted July 27, 2009 Share Posted July 27, 2009 I tried your second suggestion on that, after typing in: =IF(Isnumber([D4]), [D4],MID([D4],2,9)) I got an error message and when I double clicked on the cell, this showed up.... =IF(Isnumber([R[-1]C[-5]]), [R[-1]C[-5]],MID([R[-1]C[-5]],2,9)) Any ideas? You're supposed to replace the brackets around [cell] too. So the correct code would actually be: =IF(Isnumber(D4),D4,MID(D4,2,9)) Link to comment Share on other sites More sharing options...
GreenFire63 Posted July 27, 2009 Share Posted July 27, 2009 Silly me. You're awesome. Many thanks. Billionaire status as of 7/19/2009 Link to comment Share on other sites More sharing options...
AgingMiser Posted July 27, 2009 Share Posted July 27, 2009 Silly me. You're awesome. Many thanks. Welcome. :] Link to comment Share on other sites More sharing options...
lamia_rog Posted July 28, 2009 Share Posted July 28, 2009 Thanks Brainy for the guide. Made this Herblore Sheet with it. http://spreadsheets.google.com/pub?key= ... utput=html Link to comment Share on other sites More sharing options...
opeious Posted September 11, 2009 Share Posted September 11, 2009 Pwnzorg guide 10/10! Check out my puny :? enchanted bolt guide http://spreadsheets.google.com/ccc?key= ... RcWc&hl=en Barrows Drops:....................................................Dragon Drops:...............Other Drops: Dharok: 2 Helms, 1 Top, 2 Legs, 4 Axes.......................2 Claws Split..................1 Bandos Tassets Karil: 1 Coif, 1 Top, 2 Skirt, 2 Crossbows......................3 Plate legs...................4 Berserker RingsAhrim: 3 Hood, 2 Top, 3 Skirt, 1 Staff..........................2 Plate Skirts.................2 Warrior RingsVerac: 1 Helm, 3 Tops, 2 Skirts, 1 Flail..........................1 Med........................1 Archer RingGuthan: 2 Helm, 5 Tops, 1 Skirt, 0 Spear.....................1 Shield Half.................1 Seers RingTorag: 2 Helms, 2 Tops, 5 Legs, 1 Hammer....................4 Hatchets..................1 Missed Divine Sigil (was at bank -,- fml) Link to comment Share on other sites More sharing options...
brainymidget Posted September 11, 2009 Author Share Posted September 11, 2009 Oo Aging Miser I like it. Edited that to include the Concat and it worked. Here's what I used for Dragon Pickaxe. =MID(Index(ImportHtml(Concat("http://itemdb-rs.runescape.com/results.ws?query=",A5),"table",2),2,3), 1,3)*1000000 Link to comment Share on other sites More sharing options...
TyrantElf Posted November 3, 2009 Share Posted November 3, 2009 I was wondering if i could copy this to another forum, You will get full credit, and i think it will really help! Proud Ubuntu User!There are no stupid questions, just stupid people. -Scott AdamsA computer once beat me at chess, but it was no match for me at kick boxing.-Emo PhillipsMy Blog! Link to comment Share on other sites More sharing options...
Shelby_Polo Posted November 16, 2009 Share Posted November 16, 2009 EDIT: Nevermind I figured out my question... :unsure: Suggest a poll for Tip.it - Here! Link to comment Share on other sites More sharing options...
Maxingmck Posted November 17, 2009 Share Posted November 17, 2009 how do i turn something with k at the end (19.4k) for example to 19400 Noobs: We pay we sayJaGeX: How much will you pay? Link to comment Share on other sites More sharing options...
AgingMiser Posted November 18, 2009 Share Posted November 18, 2009 If the price of an [item] is listed as ___k in the GE Database, use this code to isolate the number: =MID(Index(ImportHtml("http://itemdb-rs.runescape.com/results.ws?query=%22[item]%22","table",2),2,3), 1,#)*1000 The code to isolate a number in the millions is almost identical: =MID(Index(ImportHtml("http://itemdb-rs.runescape.com/results.ws?query=%22[item]%22","table",2),2,3), 1,#)*1000000 Good [cabbage], do people even bother to read the thread to see if their question's been answered yet? Link to comment Share on other sites More sharing options...
Maxingmck Posted November 18, 2009 Share Posted November 18, 2009 i didnt understand it lol Noobs: We pay we sayJaGeX: How much will you pay? Link to comment Share on other sites More sharing options...
broholt Posted November 19, 2009 Share Posted November 19, 2009 What mid does is to read what is says, as simple as that.So you want it to read anything but the k and then multiply by 1000like: 19.4k you want it to read: 1,41,4 is: 1 - 9 - . - 4So it is now: 19.4 =MID(Index(ImportHtml("(InsertHtml)","table",2),2,3), 1,4)*1000 Mills: multiply by 1.000.000199.4kIs: 1,5 Link to comment Share on other sites More sharing options...
Maxingmck Posted November 19, 2009 Share Posted November 19, 2009 so what would the entire code be? im using =Index(ImportHtml(Concat("http://itemdb-rs.runescape.com/results.ws?query=",C5), "table", 2),2,3) right now hwo would i add the k in Noobs: We pay we sayJaGeX: How much will you pay? Link to comment Share on other sites More sharing options...
AgingMiser Posted November 20, 2009 Share Posted November 20, 2009 =MID(Index(ImportHtml("http://itemdb-rs.runescape.com/results.ws?query=%22[item]%22","table",2),2,3), 1,#)*1000 You don't need to do anything EXCEPT input the name of the item. What you do is replace the [item] with the name of the item. You've made the same mistake in the concat func modification - you didn't tell the function what item to look at. Link to comment Share on other sites More sharing options...
Maxingmck Posted November 20, 2009 Share Posted November 20, 2009 =MID(Index(ImportHtml("http://itemdb-rs.runescape.com/results.ws?query=%22clean ranarr%22","table",2),2,3), 1,#)*1000 i get #error Noobs: We pay we sayJaGeX: How much will you pay? Link to comment Share on other sites More sharing options...
AgingMiser Posted November 21, 2009 Share Posted November 21, 2009 =MID(Index(ImportHtml("http://itemdb-rs.runescape.com/results.ws?query=%22Ranarr%22","table",2),2,3), 1,#)*1000 "Clean ranarr" is not the name of an item you genius. Link to comment Share on other sites More sharing options...
Maxingmck Posted November 21, 2009 Share Posted November 21, 2009 o Noobs: We pay we sayJaGeX: How much will you pay? Link to comment Share on other sites More sharing options...
Maxingmck Posted November 22, 2009 Share Posted November 22, 2009 clean ranarr IS an item, check ge database, genious EDIT: still says error Noobs: We pay we sayJaGeX: How much will you pay? Link to comment Share on other sites More sharing options...
Myweponsg00d Posted November 23, 2009 Share Posted November 23, 2009 Clean_ranarr And you replace the # sign with a number. Need assistance in any of these skills? PM me in game, my private chat is always ON Link to comment Share on other sites More sharing options...
gorillekitue Posted November 23, 2009 Share Posted November 23, 2009 I only seem to get the Loading... message no matter how long I wait :/ Link to comment Share on other sites More sharing options...
Kaphias Posted November 24, 2009 Share Posted November 24, 2009 I only seem to get the Loading... message no matter how long I wait :/Occasionally this seems to happen. Best solution I've found is to simply wait and try again later. 8,325th to 99 Firemaking 3/9/08 | 44,811th to 99 Cooking 7/16/084,968th to 99 Farming 10/9/09 | Runescaper August 2005-March 2010Tip.it Mod Feb. 2008-Sep. 2008 | Tip.it Crew Sep. 2008-Nov. 2009 Link to comment Share on other sites More sharing options...
gorillekitue Posted November 24, 2009 Share Posted November 24, 2009 I only seem to get the Loading... message no matter how long I wait :/Occasionally this seems to happen. Best solution I've found is to simply wait and try again later. Works just fine today, thank you Kaphias Link to comment Share on other sites More sharing options...
Maxingmck Posted November 24, 2009 Share Posted November 24, 2009 soo whats the code for clean ranarr? i was using =Index(ImportHtml(Concat("http://itemdb-rs.runescape.com/results.ws?query=",C6), "table", 2),2,3) Noobs: We pay we sayJaGeX: How much will you pay? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now