Calculating percentages - error

[beccyg11]

Please help

I am trying to calculate data and find the increased or decreased percentage between weeks: see below
:[TABLE="width: 221"]
<tbody>[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][TABLE="width: 500"]
<tbody>[TR]
[TD]A1[/TD]
[TD]A2[/TD]
[TD]A3[/TD]
[/TR]
[TR]
[TD][TABLE="width: 221"]
<tbody>[TR]
[TD]Actions on Page (this wk)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Actions on Page (last wk)[/TD]
[TD]total action %[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]0[/TD]
[TD]0.00%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

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