Any Excel Pro's Out There?

[acearchie]

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

 

[dianeoforegon]

Ask on the Excel Forum:

http://www.officeformac.com/ProductForums/Excel/

 

[Gregg2]

Ask on the Excel Forum:

http://www.officeformac.com/ProductForums/Excel/

There's one called "Mr. Excel" also, and I'm sure there are others.

 

[gauchogolfer]

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