formula error

  • Thread starter Thread starter Sean
  • Start date Start date
S

Sean

Hi,

I am trying to find the difference in sales from what our
company has sold to what our supplier has sold. However, I
keep getting an error message or a zero. Can anyone help?

A1 = 500, b1 =450, c1=0
A2 = 458, b1 =372, c2=DIV/0!

Thanks,
Sean
 
Sean, you should provide at least
1) what those numbers mean
2) the formula you're trying
3) what result you expect (in C)

also, B1=372 should be B2=372?
 
Sorry,
A = Shipments, B= Supplier Sales, C = Percentage difference
A1 = 500, b1 =450, c1=0 (formula = IF(ISERROR((SUM
(A1/b1))),"0",(SUM(A1/b1)))
A2 = 458, b1 =372, c2=DIV/0!
Thanks
Sean

Colun
 
Back
Top