# Thread: Formula needed for comparing change in bond prices (Excel)

1. ## Formula needed for comparing change in bond prices (Excel)

<img src=/S/confused3.gif border=0 alt=confused3 width=45 height=45>

Hi,

I can't believe the sheer quality of help I continue to get from this site, thanks to all those assisting me with formulas thus far, it is greatly appreciated!!!

My current quest for a formula should answer the following question: How can I tell if a price increased/decreased 40% or more in a two day increment??
An example of this data set is enclosed to give you an idea of what I'm working with....

Thanks for your help-
Lori

(fyi: this is not a double posting)--I posted a similar question for a different type data, but cannot seem to transfer the logistics for this scenario...)

2. ## Re: Formula needed for comparing change in bond prices (Excel)

You could enter the following formula in B4 and fill down to the end of the data:

=OR(A4/A2>1.4,A4/A2<0.6)

Alternatively, you could use this formula in Conditional Formatting.

3. ## Re: Formula needed for comparing change in bond prices (Excel)

Thanks for the formula Hans!

What if I have to use this same process, but working the formula horizontally?? Example attached...

Lori

4. ## Re: Formula needed for comparing change in bond prices (Excel)

Exactly the same idea: for example, to compare A2 and C2:

=OR(C2/A2>1.4,C2/A2<0.6)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•