Want to be able to write formulas referencing web query info

[TBL]

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

 

[PaddyD]

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]

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]

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