Want to be able to write formulas referencing web query info

TBL

New Member
Joined
Nov 10, 2002
Messages
2
Hi all,

I just started using refreshable web queries and I can't seem to reference the data in a forumla. I repasting everything as values and that didn't seem to work. Any advice...?

Thanks
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
Hi - welcome to the board.

I hgave a suspicion I know what your problem is, but care to give us a little more info first...what data are you bringing in? what are you trying to reference, what formula(s) are you using, what errors are you getting etc...

paddy
 

TBL

New Member
Joined
Nov 10, 2002
Messages
2
Well I'm bringing in a table which contains about 15 columns worth of numbers formated in various ways. Some are without decimals some have decimals with up to thousandths and some decimals just to tenths. I'm trying to plug in an if statement to return a value based on informations between two rows of the table. For Example (If($B$1<B2,-1,if($B$1=B2,0,if($B$1>B2,1,"")


It's not that I'm getting an error message but excel doesn't seem to recognize that there's any data in the cells at all it's giving me a blank or whatever I plug into the formula to return for not applicable. The weird thing is that I can see that the value shows up in the formula bar.
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
my guess is that your numbers are being held as text values. tesxt this with =isnumber() on one of the cells in question. if it returns false, do the following:

1) select an empty cell & copy it
2) select the range of text 'numbers'
3) go edit |paste special | add.

this will convert the text 'numbers' to genuine number values.

paddy

EDIT: although unless

(If($B$1B2,1,"")

has typos, it's not syntactically valid for excel
This message was edited by PaddyD on 2002-11-11 18:22
 

Watch MrExcel Video

Forum statistics

Threads
1,122,521
Messages
5,596,652
Members
414,083
Latest member
Mrsash

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top