nested function

I am having trouble with a nested web scraping section breaking my Do Until Loop. I have a list that I am creating a unique file with two tabs. One contains some basic header information which I want to use to get the most relevant website and add the link. Then save, close and move on to the...

Hi! I am very new to Excel VBA. Please help me figure out how to build nested data validation drop down lists. I do know how to build hierarchical data validation lists. The current situation is I have three drop down lists called committees, membership categories and companies, under each...

Hi! I'm trying to create a formula to tell me which products should ship via UPS Ground (any product with dimensions of 1 cubic foot or more), which should ship via USPS Priority Mail (any other product with dimensions < 1 cubic foot but that WEIGHS 1 lb or more), and have anything weighing < 1...

Hello Everyone! How to nest the long excel formula in vba using WorksheetFunction? Here is my goal... I need to convert the following into Minutes Column A - Column B(mins) 0Day(s), 5Hour(s), 25Min(s) - 325 4Day(s), 7Hour(s), 11Min(s) - 6191 7Day(s)...

I have purchase date (A), cost (B), depreciation rate (C), accumulated depreciation (D), in columns A to D and months in columns E onwards. I have used nested "if" function: =ROUND(IF((AND(D2<B2,A2<=$E$1)),B2*C2/12,0),2) to calculate depreciation for each month (in adjucent columns). I want to...