Two Formulas for One Cell Using IF

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COMPARING TIMES AND DISPLAYING TEXT USING IF CONDITION 3
split range address into individual cell addresses 4
Baffeling IF statement 7
Funtions return wrong result BUG in Execel ??? 8
Merging cells and formats 8
increasing or decreasing a cell 16
Adding Cells, Get Error. 2
If, Or function or macro to compare 3 columns of numbers 3

Top