I have one column A with Forecasted numbers, and column B with Actual numbers.

I am trying to create an accuracy formula, which takes in consideration 0's.

This is what I have:
=IFERROR((A1/B1),"0%") I need to do an IFERROR, because some numbers in column A or B are "0's), and since we can't divide into 0's, the error will be replaced with 0% accurate.

So if I forecasted 0, and sold 2, the above formula will throw "0%"
If I forecasted 2 and sold 0, the above formula will also throw "0%".

However, when columns A and B both contain 0's (I forecasted 0, and sold 0) I will get a "0%". In this case, forecasting 0 and selling 0, should be 100% accurate. So I wanted to incorporate:

IF(A1=B1,"100%") into the IFERROR formula.. but I can't do it. Excel says that I have entered too many arguments,
when I enter: =IFERROR((A1/B1),"0%",IF(A1=B1),"100%"))

Any thoughts on how to combine these two? maybe I'm not combining them properly.

Any help will be appreciated!
(I'm using Excel 2007)