JasmineSilver
New Member
- Joined
- Mar 18, 2017
- Messages
- 4
Hello all! I'd like to use the formula below but with one modification. Where it says "tritanium=1211562705", I'd like to be able to remove the numbers there and have the formula pull the number from a specific cell.
The formula:
=IMPORTXML("http://api.eve-industry.org/highsec-compression.xml?rate=72.4&tritanium=1211562705", "//eve-industry-api")
Here's what I've tried so far, but get errors every time:
tritanium="C22""
tritanium="C22"
tritanium=INDIRECT"C22"
tritanium=INDIRECT"C22""
tritanium=(INDIRECT"C22")")
tritanium==(INDIRECT"C22")"
and so on and so forth. I'm very new to spreadsheeting, so I'm still learning. I'm using Google Sheets btw, because so far I haven't been able to get this and other similar scripts and formulas to work in Excel.
So, does anyone know how I can reference a cell there instead of manually inputting a number?
Thank you very much for your help!
The formula:
=IMPORTXML("http://api.eve-industry.org/highsec-compression.xml?rate=72.4&tritanium=1211562705", "//eve-industry-api")
Here's what I've tried so far, but get errors every time:
tritanium="C22""
tritanium="C22"
tritanium=INDIRECT"C22"
tritanium=INDIRECT"C22""
tritanium=(INDIRECT"C22")")
tritanium==(INDIRECT"C22")"
and so on and so forth. I'm very new to spreadsheeting, so I'm still learning. I'm using Google Sheets btw, because so far I haven't been able to get this and other similar scripts and formulas to work in Excel.
So, does anyone know how I can reference a cell there instead of manually inputting a number?
Thank you very much for your help!