Excel Problem really driving me....

TWI

Senior member
2,527 252
Have DDE links from trading platform to Excel to show my position.
Lets say position DDE is at ref A10
and filled price pulled in at ref B10
Now want to reference that cell with:
if(abs(A10)>0,B10,0)
This just gives me
#value
no matter what I try I cannot seem to overcome this.
Any help would be gratefully received.
T/.
 

youwho

Junior member
27 1
These errors usually occur when the syntax is wrong (i.e. you have too many brackets or the comma is in the wrong place etc) take a look at you formula again, its an easy oversight to make which we all do. Otherwise just revert to closing the spreadsheet and reopening it again, and if that doesn’t work go and buy an abacus.
 

TWI

Senior member
2,527 252
No error in the calc and closing then reopening doesn't work either.
I was wondering if it is something to do with the nature of the data that is being DDE'd and how it is seen by Excel because when there is nothing there it is certainly not recognised as " " or 0
Do u know a good online abacus retailer?
 

Trader333

Moderator
8,601 931
Twalker,

You can try 2 things here:

1) Widen the cell width of the refernce cell as it may just be too narrow to display the number

2) I presume you prefixed the cell reference with "=" so that your formula reads

=if(abs(A10)>0,B10,0)

I have just tried using the same formula and it works fine for me so I would guess it is one of the above that is causing your problem.


Paul
 

TWI

Senior member
2,527 252
Yep to all. Seems to be a problem recognising the DDE link as a zero value, fine when it has a value in it. When there is no value I get the #value no matter how I try to reference it.
 
 
AdBlock Detected

We get it, advertisements are annoying!

But it's thanks to our sponsors that access to Trade2Win remains free for all. By viewing our ads you help us pay our bills, so please support the site and disable your AdBlocker.

I've Disabled AdBlock