Two Formulas for One Cell Using IF
 

Hello,

I am having a time with this one. I am close, but just can't get there. I
have 5 columns A, B, C, D, and E. If A1 has a value, E1 would equal
(A1-C1)/C1. If B1 has a value, E1 would equal (B1-D1)/D1. If column A has a
value, C will not and vice-versa. How would I do a formula for this?

I appreciate any help in this.

Thank you,
--
Andrew C

Two Formulas for One Cell Using IF
 

One way,

=IF(A1="",(B1-D1)/D1,(A1-C1)/C1)

HTH,
Paul


"Andrew C" wrote in message
...
Hello,

I am having a time with this one. I am close, but just can't get there.
I
have 5 columns A, B, C, D, and E. If A1 has a value, E1 would equal
(A1-C1)/C1. If B1 has a value, E1 would equal (B1-D1)/D1. If column A
has a
value, C will not and vice-versa. How would I do a formula for this?

I appreciate any help in this.

Thank you,
--
Andrew C

Two Formulas for One Cell Using IF
 

Thank you, that worked fine!
--
Andrew C


"PCLIVE" wrote:

One way,

=IF(A1="",(B1-D1)/D1,(A1-C1)/C1)

HTH,
Paul


"Andrew C" wrote in message
...
Hello,

I am having a time with this one. I am close, but just can't get there.
I
have 5 columns A, B, C, D, and E. If A1 has a value, E1 would equal
(A1-C1)/C1. If B1 has a value, E1 would equal (B1-D1)/D1. If column A
has a
value, C will not and vice-versa. How would I do a formula for this?

I appreciate any help in this.

Thank you,
--
Andrew C