View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Andrew C Andrew C is offline
external usenet poster
 
Posts: 10
Default 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