Get instant live expert help on I need help with vba switch case

I am working on switch statements in excel.i a writing formula for a column which contains decimal values from 30 to 100. My formula is Switch(F2,"or(F2>30,F2<=36)",..........),the problem here is that this(OR(F2>30,F2<=36)) is not working.What should i do if i want to use limits(For example : 30 to 36,36-50,etc) in switch case statements.

I'm trying to work in VBA to pull data and run a calculation based on a selection. I'm using getbeta to retrieve the calculation based on the selection and a function to run the calculation. This is what I've written that gives me a null value: Function GetBeta(FA As Double, SoilType As String) As Double 'Calculate the Beta Coefficient based on Friction Angle and Soil Type Select Case SoilType Case SoilType Is "Clay" Select Case FA 'Use Clay Curve Case Is < 25: GetBeta = 0.23 Case 25 To 34: GetBeta = GetBeta = 0.0147 * Exp(0.1101 * FA) Case Is > 34: GetBeta = 0.5 End Select End Function

I am facing an issue in my financial model. I created a worst, base and best case scenario and a switch to control the input variables. The financial statements all work well. However, the problem is how to link the values into the Executive Summary sheet. For instance, the Net Profit in the best is $12M, base $10M and worst $8M. How do I link the cells in the executive summary to show this. For instance, 1. Best Case scenario, cell A1 = [LINK] will show $12M 2. Base Case scenario, cell A2 = [LINK] will show $10M

what is the shortcut used to switch between excel workbooks?

How do I change case from upper case to initial capital letters and secondly from lower case to uppper case