Problem: Cell A2 can be either "Categ 1" or "Categ 2". If Categ 1 is selected, a drop down list is provided in B1. Based on selection in B1's drop down list, its relative value is shown below in B2.
If Categ 2 is selected in A2, then a completely different list is shown in B1, and based on that...
Good afternoon,
I'm trying to build an equation that will assign a particular value to a data set depending on if that value is <, between, or > than a certain value. Disregard flows for now, that will be coming from a separate spreadsheet. The remaining five categories are all on one...
Hi there - I'm sure this is fairly easy but I can't make it work and keep getting error messages, so would be most grateful for some guidance please.
This is what I'm trying:
=SUM(Y8/(R8:W8))
So the result would equal the number in cell Y8 being divided by the number created by adding...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.