I'm trying to set up a formula where I have three checkbox options linked to the same cell. Example: If checkbox in cell A1 is selected it displays a price of $100 in cell B1, If checkbox in cell B2 is selected A1 displays $300, If checkbox in cell B3 is selected A1 displays $500. I tried using IF, but I can't figure out how it works with more than 2 options. Maybe I am using the wrong function for this task. Any help would be appreciated, Thanks, Aaron
Solved by M. B. in 19 mins