Any Excel Pro's Out There?

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

  1. acearchie macrumors 68040

    acearchie

    Joined:
    Jan 15, 2006
    #1
    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?

    Thanks
     
  2. Gregg2 macrumors 603

    Joined:
    May 22, 2008
    Location:
    Milwaukee, WI
    #3
  3. gauchogolfer macrumors 603

    gauchogolfer

    Joined:
    Jan 28, 2005
    Location:
    American Riviera
    #4
    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