by mblow01@hotmail.com :: Fri, 08/12/2011 - 10:13am
I can't seem to generate any auction values when I generate KUBIAK. I followed the instructions (I think) and all I get in the auction value columns is "#DIV/0!". If someone can help that would be awesome.
Go to the Baselines tab and see what it says for the Auction Adjustment. If that also says #DIV/0, then that means it's not adding up the sum of row CZ of the Cheatsheets tab properly. What kind of values are you seeing in row CZ? Are there any other cells giving error messages?
Re: Auction Draft
It did last year. I imagine it will again.
Re: Auction Draft
I can't seem to generate any auction values when I generate KUBIAK. I followed the instructions (I think) and all I get in the auction value columns is "#DIV/0!". If someone can help that would be awesome.
I am an absolute zilch when it comes to Excel.
-Matt
Re: Auction Draft
Go to the Baselines tab and see what it says for the Auction Adjustment. If that also says #DIV/0, then that means it's not adding up the sum of row CZ of the Cheatsheets tab properly. What kind of values are you seeing in row CZ? Are there any other cells giving error messages?
Post new comment