Please help
I am trying to calculate data and find the increased or decreased percentage between weeks: see below
:
<tbody>
</tbody>
In A3 i currently have the following formula: =IFERROR(((U3-V3)/V3),0) - The issues im having is the answer to A3 should be 100% up from last week but "=iferror" forces it to become 0, if i don't have the "=iferror" in there it comes up with #DIV/0!
Im also wanting to put conditional formatting icons to have a green arrow if increased from the week before(A2) and red arrow if decreased from week before(A2) but not sure how?
Please help
I am trying to calculate data and find the increased or decreased percentage between weeks: see below
:
<tbody> </tbody> |
<tbody>
</tbody>
In A3 i currently have the following formula: =IFERROR(((U3-V3)/V3),0) - The issues im having is the answer to A3 should be 100% up from last week but "=iferror" forces it to become 0, if i don't have the "=iferror" in there it comes up with #DIV/0!
Im also wanting to put conditional formatting icons to have a green arrow if increased from the week before(A2) and red arrow if decreased from week before(A2) but not sure how?
Please help