1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How to calculate a value based on multiple dropdown lists

I have 3 dropdown lists created, where each option in each list has a corresponding value. The value is written in the column directly to the right of the list option. All the values are 1 or lower, ie. 0.9, 0.8 and so on.

I'm looking for a formula to put in an empty cell that will automatically calculate a value based on the options chosen in the 3 dropdown lists. In this particular case, the value should never be higher than 12. This is why the values that correspond to the dropdown list options have a maximum of 1.

Basically, I want the number 12 to be multiplied by all 3 values that correspond with the options chosen 3 dropdown lists.

Is there any formula could do this? Do I have to change something first?

submitted by /u/YesNoIDKtbh
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#AI formula generation techniques
#Excel alternatives for data analysis
#formula generator
#rows.com
#cloud-based spreadsheet applications
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#financial modeling with spreadsheets
#Excel alternatives