Growth based on 2 Conditions

[nsd3]

The yellow cell on the Desired Result A (Attached file) requires a formula that shows the growth % number. I've used the formula :

IF(OR(C2=0,D2=0),0,(D2/C2-1))

But this gives me Desired Result B but I need to have both A and B as desired result in that formula.

Thanks in advance for your help. Cheers!

[tigeravatar]

nsd3,


Give this formula a try. Is it what you're looking for?
=IF(C2=0,1,IF(D2=0,0,C2/C2-1))

Hope this helps,
~tigeravatar

[nsd3]

Thank you! I had to edit the cell references to get what I wanted:

IF(D3=0,1,IF(E3=0,0,E3/D3-1))

Thank you very much!