Reverse fold change values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
Sorry about the form of this question, I'm not very good at explaining
things!!

I have compared values in conditionA against condition B. It is a
unidirectional comparison in that I cannot compare condition B against
conditionA.
Say that Condition A has a value of 10 and condition B has a value of 2, I
will get a fodl change value of 5, in that Condition A is 5 fold greater than
conditionB.

However if condition A has a value of 2 and conditionB has a value of 10,
then I get a fold value of 0.2, even though the fold change is the same, it's
just the direction of the fold change that is different.

Can excel take the 0.2 and convert it back to a fold of 5 without having any
other information?
thanks for any help you can offer me with this!
 
toriaw said:
Hi
Sorry about the form of this question, I'm not very good at explaining
things!!

I have compared values in conditionA against condition B. It is a
unidirectional comparison in that I cannot compare condition B against
conditionA.
Say that Condition A has a value of 10 and condition B has a value of 2, I
will get a fodl change value of 5, in that Condition A is 5 fold greater
than
conditionB.

However if condition A has a value of 2 and conditionB has a value of 10,
then I get a fold value of 0.2, even though the fold change is the same,
it's
just the direction of the fold change that is different.

Can excel take the 0.2 and convert it back to a fold of 5 without having
any
other information?
thanks for any help you can offer me with this!
Click to expand...


use an IF statement. =IF(A>B,A/B,B/A)

HTH
 
Back
Top