Any Excel Pro's Out There?

Discussion in 'Mac Apps and Mac App Store' started by acearchie, May 29, 2011.

  1. acearchie macrumors 68040


    Jan 15, 2006
    Hi guys,

    Basically I am trying to create an excel spreadsheet that basically shows me what equipment I could buy with the money I have.

    I would like to be able to have a list of items with there prices and then have radio buttons alongside each one.

    If I click the radio buttons it then "activates" the item and the total cost only takes into account the cells with the radio buttons activated.

    This way I can set out the items that I am looking to purchase and do a sort of pick-and-mix of the items to find the right combination in the right price range!

    Could anyone help me with adding the buttons and the relevant formula so that the total cost only takes into account the "activated" cells?

  2. Gregg2 macrumors 603

    May 22, 2008
    Milwaukee, WI
  3. gauchogolfer macrumors 603


    Jan 28, 2005
    American Riviera
    simplest way: have the button toggle a cell next to your price between 0 and 1, then multiply by your price cell. Sum all.

Share This Page