July 26, 200916 yr 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))
July 27, 200916 yr 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
July 27, 200916 yr 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))
July 28, 200916 yr Thanks Brainy for the guide. Made this Herblore Sheet with it. http://spreadsheets.google.com/pub?key= ... utput=html
September 11, 200916 yr 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)
September 11, 200916 yr Author 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
November 3, 200916 yr 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!
November 16, 200916 yr EDIT: Nevermind I figured out my question... :unsure: Suggest a poll for Tip.it - Here!
November 17, 200916 yr 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?
November 18, 200916 yr 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?
November 19, 200916 yr 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
November 19, 200916 yr 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?
November 20, 200916 yr =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.
November 20, 200916 yr =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?
November 21, 200916 yr =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.
November 22, 200916 yr clean ranarr IS an item, check ge database, genious EDIT: still says error Noobs: We pay we sayJaGeX: How much will you pay?
November 23, 200916 yr 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
November 24, 200916 yr 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
November 24, 200916 yr 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
November 24, 200916 yr 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?
Create an account or sign in to comment