Get instant live expert help on I need help with excel case function

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Excel DATA TABLE feaute does not work and the solver function keeps telling me that there is a Solver window open when it is not the case
Solved by D. W. in 20 mins
how to add a plus (+) to hide and unhide the row and column in excel in case i would not use the "hide" function
Solved by B. B. in 13 mins
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
Solved by Z. L. in 22 mins
How can I fold text from upper case to Title Case in an EXCEL cell/workbook?
Solved by T. J. in 17 mins
Is it possible for excel to lower case or upper case the words on a cell and if it is a name only the first character is uppercase and the rest is lower case?
Solved by O. D. in 13 mins