Calculate a Percentage in a cell ONLY if two seperate cells have a value greater than zero

[espyder]

Hi,
I have a CELL(A), which has a default value of 0%. I would like CELL(A) to show the percentage of change between CELL(B) and CELL(C). By Default CELL(B) and CELL(C) have a value of "0.00"
ONLY when BOTH CELL(B) AND CELL(C) have values above "0.00", than I would like to populate CELL(A) with the percentage change.

I am stumped on this one. I had thought something like this might have work:
=IF C>0,B>0,C-B/C

As you can see, I am far from a solution...
Thanks!

[oeldere]

a1=if(and(b1>0,c1>0),(c1-b1)/c1,"")

[espyder]

Thanks oeldere,
That worked like a charm!
Could you show me how to do the same calculation, but instead expanding it into columns instead of a CELL?

For example:
a1=if(and(b1:b100>0,c1:c100>0),(c1:c100-b1:b100)/c1:c100,"")

CELL a1 would adjust accordingly every time a number greater than "0" was placed in both adjacent cells. So CELL a1 would change ONLY if CELL c50 AND b50 had a value greater than "0"

Thanks!!

[oeldere]

Just copy the formula in cel a1 and drag the formula down to the cells below.

Then the formula expands to your needs (if I understand your question well enough).

Just try it and reply if this is what you want to achieve.

[espyder]

Hi,
thanks so much for all your help.
I have attached an example spreadsheet with what it is I am trying to accomplish
Thanks!