Results 1 to 13 of 13

Excel 2007 : Finding Values from the Total Sum

Threaded View

  1. #9
    Forum Contributor SCLai's Avatar
    Join Date
    08-18-2010
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    129

    Re: Finding Values from the Total Sum

    Oh for the circular.. please set Iteration to... maybe 10?
    Tools > Options > Calculations tab > Iteration check box & value to 10

    Edit: Sorry, also pls change formula in Cell E9 to
    =IF(OR(H9=3,E10=3),1,IF(AND(F9+G9<H9,E7+E8<E10),1,0))
    Last edited by SCLai; 05-09-2012 at 01:33 AM.
    Do give a * (bottom left) if the post helped!

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