complex

I get "Expression too complex" when attempting this: Suggestions/remedy greatly appreciated. Select Case Val(ws.Cells(iRow, 18).Value) Case Is <= Val(Sheets("Settings").[A90]): OptionButton1 = True Case Is > Val(Sheets("Settings").[A93]): OtionButton4 = True...

Greetings, Im working with a template that has the following expression: =IF(AND($B10="Goal",H$5>=$E10,H$5<=$E10+$F10-1),2,IF(AND($B10="Milestone",H$5>=$E10,H$5<=$E10+$F10-1),1,"")) The value in Column F is currently # of days - I'd like to change that to an End Date and would really like some...

HI Everyone, I am trying to calculate readings based on readings entered previously and then readings entered after the date. I know this might be a complex formula or simple for some, but I can't seem to figure it out. <tbody> Date Readings Calculated Reading 11-1-2018 60 60 11-2-2018...

I have a nested IF OR formula, but both of the criteria to evaluate has the same result. My formula is: <colgroup><col width="64" style="width: 48pt;"> <tbody> <colgroup><col width="64" style="width: 48pt;"> <col width="76" style="width: 57pt; mso-width-source: userset; mso-width-alt...

Hi, Following the brilliantly fast response I got yesterday, I thought I'd try a trickier question. I'll be honest, I think of myself as good with excel but am very capable of getting completely lost when it comes to complex formula! I've got a SUMIFS formula which picks up spend of a...

Hi, I have a complex formula that I am using for calculation of potential for employees receiving a bonus. It is based on limits of percentages. The formula looks like this: =IF(C33="THRESHOLD",C29*0.5,IF(C33="target",C29,IF(C33="max",C29*1.5))) In essence there is a drop down with the words in...

I would like the following values to populate based on dates: if date is 08-31-18 then 1 if date is 09/30/2018 then 2 ................................................................................. if date is 07/31/2019 then 12 What is the best way to do it? the if formula becomes too...

Hi Team, I need one formula..Condition are like below.. In Col A, A2 Admin Project 1 A3 Admin Project 2 A4 Admin Project 1 A5 Admin Project 1 A6 Admin Project 2 A7 Admin Project 1 A8 Admin Project 3 A9 Admin Project 2 A10 Admin Project 3 A11 Admin Project 1 like this.. Against this I have in...

Everyone knows Excel can continue 1,2,3... to 4,5,6 and Monday, Tuesday, Wednesday to Thursday, Friday, Saturday. But what if the sequence is much more complex? Like for example, given list: 10 6,025 3,77 2,52 1,77 1,32 1,01 0,805 0,645 0,53 give me the 50th entry on that list. What's the...

I'm looking for a best practice as to how to handle changing measures when your source data changes. We're in a (continual) fact-finding mode with our data. The extracts from our various ERP systems are complex, such that the names and logic of columns can change as we slice 'n' dice and come...

Ok this one, in my mind is complex. I'm hoping someone can tell me I'm wrong. Scenario: Creating a weekly schedule breaking out each Day as its own sheet with at least 30 users listed. Breakdown: 1. Each sheet has 15 min increments for scheduling 2. Each cell within those 15 min increments has...

I'm looking for some help as whilst I have a basic working knowledge of excel, in my job I'm fast having to get to grips with more complex formulas. I need to work out the total cost for something, where you have a flat rate, and then an additional cost that changes depending on how much of...

I am relatively new to VBA, which I've been using to solve basic problems and automate reasonably complex tasks for my workplace. My most complex one (so far!) is actually two documents: a data source housed in Excel and then the merge letter in Word. Rigging the Word document to do what I want...

Hello, Thank you in advance for your help. I have a complex formula issue, at least for me it is. I need a formula that has the following conditions: I need to count the number of times a word shows in column D but only if column E says "NEW" or "RET". Then I need to take that result and if...

hi my name is Deepak i need a help how to do a complex formulas i have done all single formulas but i don't know how to do a complex formulas when to use and how to use please guide me. Thank you

Hi all, I am really stuck with what I want to do. Columns A to C holds information about our customer base who buy or sell us stock. I am looking to create the results shown in E1:G4 automatically, with scope for this to automatically expand if a new customer name is added in column A. A few...

Hi, Was wondering if anyone could take 5 minutes to review one of my spreadsheets. I have completed it to a good standard but was wondering if any one could provide feedback? It's not very complex so doesn't require a genius, although any help would be great! Thanks,

Hi - I have a complex sheet with at least 100K entries on it with following columns:- Name | Work Email | Personal Email Work Email & Personal Email column have many duplicates on it. How to remove it via excel formula? So that original data is not disturbed please. Regards

<tbody> < 2% 2 to 5% 5+ to 8% 8+ to 11% 11+% 0 to 10% 0.6 0.8 1 1 1.25 10+ to 15% 0.8 1 1 1.25 1.35 15+ to 25% 1 1.25 1.25 1.35 1.5 25+ to 35% 1.25 1.35 1.5 2 2.25 </tbody> Column growth: X Row growth: Y Multiplier: Z Given this table, I would like to write a formula...

Hi, New here. This may be a very simple question: Worksheet 2: I have a list of 30 apartment complexes, cells A1:A30. Cells B1:B30, there is a corresponding dollar amount for each apartment complex. Worksheet 1: In cell A1, I have a dropdown list with the names of the apartment...