hsandeep
Well-known Member
- Joined
- Dec 6, 2008
- Messages
- 1,215
- Office Version
- 2010
- Platform
- Windows
- Mobile
1. I have 2 columns with numerical values; say A1 = 130.25 & B1 = 118.68.
2. I have designed 3 arrows (representing UP, DOWN & EQUAL) & have inserted in 3 separate cells, say, R1, S1 & T1.
3. C1=A1-B1 (formula).
4. I want corresponding arrows to be grasped (from either R1, S1 or T1) based on the result in C1 & shown in cell C1. It has to be à If C1=+ve then get R1, -ve get S1, =0 get T1. HOW TO DO THIS?
5. A1 & B1 are DDE feeds & keeps on changing frequently, thus cell C1 should also keep its pace. I am using excel2007.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Thanks in advance. Please do help. Please.
<o> </o>
2. I have designed 3 arrows (representing UP, DOWN & EQUAL) & have inserted in 3 separate cells, say, R1, S1 & T1.
3. C1=A1-B1 (formula).
4. I want corresponding arrows to be grasped (from either R1, S1 or T1) based on the result in C1 & shown in cell C1. It has to be à If C1=+ve then get R1, -ve get S1, =0 get T1. HOW TO DO THIS?
5. A1 & B1 are DDE feeds & keeps on changing frequently, thus cell C1 should also keep its pace. I am using excel2007.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Thanks in advance. Please do help. Please.
<o> </o>