Hi, I've been making an online price quote calculator to be uploaded to the web, but am stood at a standstill.
I want my dropdown menu's list " 1, 2, 3, 4, 5, 6" to affect my total cost formula. (I am using data validation, but also own the Excel add-on Spreadsheet Converter)
My total cost formula is a simple =AC26 which is the total outcome of how much Item 1 would cost.
I want to be able to select Item 2 and the total cost formula to be changed to =AH26
Bookmarks