Skip to content
View in the app

A better way to browse. Learn more.

Tip.It Forum

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Google Docs html help needed

Featured Replies

I have a technical problem with google docs. As I'm sure some of you are aware, you can use google docs to track xp, store current ge prices, make calculators, etc etc. I'm making a list of items that I need and merchant frequently. Importing the data was no problem, the problem comes with calculating daily percent changes. When you import price change information from the rs item database, it attaches a plus and a minus to signifiy increases or falls. For some reason, Google docs is having difficulty understanding that a plus means positive. No issues on the minus symbol though.

 

 

 

I'm guessing that the plus sign is considered text, which is why it screws up my calculations. (though that doesn't explain why the minus works) I would just delete the plus sign, but since the data is imported from an html table you can't exactly do that. I've tried doing "=Value(text)" but that doesn't work. Could someone experienced with html help me out with this problem? An html code deleting the plus sign or a code for google docs to understand that it means positive would be GREATLY appreciated.

 

 

 

Below is the code I used to import data:

 

=Index(ImportHtml("http://itemdb-rs.runescape.com/results.ws?query=cosmic rune", "table", 2),2)

 

 

 

And code I used to convert k's and m's to *1000 and *10000000

 

=if(iferror(find("m"C50),false),left(C50,find("m",C50)-1)*1000000,if(iferror(find("k",C50),false),left(C50,find("k",C50)-1)*1000,C50))

 

 

 

^both from "How to use Google Docs to extract GE prices ~By Brainymidget" found at viewtopic.php?f=180&t=782319

 

 

 

My knowledge of html is fairly limited lol, but maybe its possible to use my conversion code to change "+" to a space or *1? Maybe work off of this fail code? hahaha

 

 

 

=if(iferror(find("+"D4),false),left(D4,find("+",D4)-1)*1,D4)

 

 

 

^it didn't work for me btw hahaha

 

 

 

Thanks :)

Billionaire status as of 7/19/2009

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.