Two Formulas for One Cell Using IF

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

Guest

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,
 
Back
Top