if and statements

This is not about Nested IF statements. Hi I am trying to output data values when 2 list box selections are true. ie. List box 1 = Player position - Left Forward Pocket -Full Forward -Right Forward Pocket etc... List box 2 = Venue -Adelaide Oval -Bellerieve Oval -Carrara etc... When: List...

I'm using Excel 2010 on Windows XP. I would like to vlookup to an excel log that tracks the dates of each time a customer was contacted. The customer may be contacted up to 4 times. I want the vlookup result to be the last time the customer was contacted. Essentially, if E2 is blank I want the...

Hello all, So I am trying to have a bit of code that recognizes all values between 3 and 5 within a range (which I will refer to as n) and if a cell value falls within this range then apply the replace the value with the following formula (n[original val] - 3) x .5) +3 Below is the code I have...

Hi, I've got a problem with an IF/And Statement and do not know if this the correct function to use. Basically I'm trying to say two things in Cell E2: IF the date in column C2 is greater than column A2 it is Late, if not its on time AND If the time in column D2 is greater than column B2 it is...

SO i am trying to add columns to establish events. In the one scenario I have four columns and one is basically a parent field and has four child fields. Two of the fields have to be added if the parent is greater than zero. The formula does not seem to be working...

Hi I have an array of Supplier numbers A1:A20 in a separate sheet 'Tier Suppliers' I also have another list of Suppliers which amount to 20000 rows. (Col A). I would like to write a nested If AND formula that checks to see if the data in the 20000 rows matches the array and another column...

I can't put an If/And formula into a cell because it has a validation list connected to it. So I need to figure out how to put the formula into a VBA code. This is what I have come up with but it's not working... Private Function FirstProcess(ByVal Target As Range) If Range("F16").Value =...

Error:You've entered too many arguments Yea, I know this is a common problem, but I'm stumped. Doing it in VBA is not an option because I need it to run at work and we are still using Excel 03 with no macros enabled Formula...

I need help with averaging with conditions Example if {'FN Project Tracking'!$M$17:$M$8546=$B22} and if{ 'FN Project Tracking'!$G$16:$G$8546="BAU" } and is more then 14 days old average # of days dates are in {'FN Project Tracking'!$L$16:$L$8546 }{ 'FN Project Tracking'!$O$16:$O$8546 } any...

Does anyone have some resources or links to good information pertaining to IF AND STATEMENTS and what a typical argument entails, thank you!

http://www.mrexcel.com/forum/showthread.php?t=356790 Please help on this thread. Thank you!!

Hello, I will say thank you in advance for all your help. I am working with a bonus project and I have corresponding % rates (for a certain percentage increase of unit sales; so for example if customer A bought 100 widgets last year and then this year he buys 105 he falls into the 101%-105%...