Calculating percentages - error

[beccyg11]

Please help

I am trying to calculate data and find the increased or decreased percentage between weeks: see below
:

A1 A2 A3 Actions on Page (this wk) <tbody> </tbody> Actions on Page (last wk) total action % 1 0 0.00% <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

 

[Aryatect]

Hi, you are changing from 0 to 1 which means it as per your formula 1/0 which is infinite and not 100%. You can default it to 100% by =IFERROR(U3/V3-1,1) but you have to note that if it changes from 0 to 5 still it will be 100%.

For CF please go to Home--> Conditional Formatting--> Icon Sets and select arrows. Then go to Manage rules and change as below:


https://drive.google.com/open?id=1ysk1cuK_B_vXGmMoP8rMSaK_7khy55N5