Testing two rows of variables for two different formula

**rdeleest1990** · 04-25-2013, 08:31 AM

Hi all,

First thanks for reading and taking the time to help me!

I have a problem I have two rows of data each containing Dollar values. What I want excel to do is to compare these with each other on basis of simple formula. The first row I will call A and the second B, they each have the same date that the value occurs. If the value in A is higher than B I would like Excel to do this: 1/A, the A being the value of that certain set of data (e.g. so for t=1). If the value of A is lower than B I want excel to do this: -1/A, again the A must be for that period (e.g. t=15).

I hope you can help me!

Greets,

Rick

**etaf** · 04-25-2013, 09:20 AM

=IF( A1>B1, 1/A1, If( A1<B1, -1/A1, "A and B are equal"))
copy down

what do you want to do with equal

not sure what the t=1 or t=15 does

or i have missed the requirement, and this is on groups of dates or statistics T tests ?

**rdeleest1990** · 04-25-2013, 09:28 AM

Thank you for your reply,
Funny that you notice it, i am actually testing for the fact if they differentiate from each other.
I have just found a way to get it done, so thanks for your response but it is solved!

gr.

Testing two rows of variables for two different formula

LinkBack

Thread Tools

Rate This Thread

Display

Testing two rows of variables for two different formula

Re: Testing two rows of variables for two different formula

Re: Testing two rows of variables for two different formula

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions