Results 1 to 3 of 3

Circular refrence necessary or is there a better way help

Threaded View

  1. #1
    Registered User
    Join Date
    04-22-2012
    Location
    Florida
    MS-Off Ver
    Excel 2007
    Posts
    2

    Circular refrence necessary or is there a better way help

    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.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1