SO i have a spreed sheet that has this circualr refrence in it. =IFERROR(SUM(I3/J3),0) =IFERROR(H3*J3, 0) where J3 is the number of units in a case of my thought process was i will be able to simply put the hard data in the field that needed it and let excel take care of the rest well obviously this is a circular error so i turned iterations on. Is there a better way to do this because ive noticed the circular refrence makes excel a little buggy. All of my vendors give pricing in a diffrent format by the bottle by the case etc and cases can come in all diffrent quantities from 3 to 6 to 12 unites in a case. So I have to have three fields with the price per case price per bottle and Qty in a case.
if you havent guessed i am dealing with wine. also as you can tell from the spreed sheet attached the file is rather sprawling so i really dont want to add any fields.
Bookmarks