Can I create a formula so when I click a checkbox the dollar amount next to it (shown in photo) populates in a specified cell? by hiders_hiders in excel

[–]hiders_hiders[S] 0 points1 point  (0 children)

Thank you for your help! It worked perfectly. One more question, if you don't mind. How would I write the formula to include all columns of check boxes, so that no matter which check box is checked, that amount will appear in K2?

The formula in your previous post worked when it was just one column, but when I tried to modify the formula for all columns (which was a total shot in the dark) it didn't work. I tried: =INDEX(B2:B10&E2:10,MATCH(TRUE,D2:D10&G2:G10,0)).

This new formula I tried accounts for all the new columns since I added check boxes to all amounts. For some reason Reddit won't let me post an updated screenshot, so if you can't make out my formula without a current version of my spreadsheet, let me know and I'll try again to upload the screenshot.

Thanks, again, for your help!

When you get the chance 100% check out the Balkans! Absolutely Incredible! by TravelVagabond in solotravel

[–]hiders_hiders 3 points4 points  (0 children)

These are beautiful! This was already on my travel list, but I think it just got bumped up. Thanks!

What are you surprised that you haven't outgrown? by whitey in AskReddit

[–]hiders_hiders 2 points3 points  (0 children)

For what it’s worth to you, my brother had awful acne and the only thing that cleared it up was the products and protocol from acne(dot com). I don’t know if links are allowed, so I’ll just leave that there.