multiple arguments

A1=1 or ""null (thr' formula) B1=HOLD or null (thr' formula) If: A1=1 and B1=HOLD; C1=100 A1=1 and B1=""null; C1=200 A1=""null and B1=HOLD; C1=300 A1=""null and B1=""null; C1=400 How to get either of C1?

Hi, Really struggling with a bit of a "minging" spreadsheet.. Each client has multiple rows (1 for each claim) and each row has 2 status fields (I2... and K2...) Theres a unique ref in column B which shows if they relate to the same client. I need to identify/filter the clients that have a...

Hey everyone . . . Got a question about a few formulas I am trying to work through. I am attempting, unsuccessfully, to create a formula that will first look at a range and make sure the selected dates are within range and then count the occurrences of a cells value that matches within a range...

I need some help writing a visual basic code that says, "If a cell in column B = "H" and the corresponding cell in column C = 0, then change the value in column C from 0 to HLB. As I am very new to VBA, the simpler the answer the better. Appreciate any help anyone can give. Thank you.

Need help with a formula on excel that I can't seem to get. Basically I trying to create a formula where the monthly interest payment is automatically calculated based in what range the monthly billing falls into, as well as what type payment it is (E33). But I have several variables. Is this...

I hope someone can help me with this or point me to a post about this. I wasn't able to find anything. :( I've figured out how to use DV Lists and Dependant Lists, but I'm unable to create multiple Dependant Lists (with varying data) to point to the value chosen in one DV List. I can't use...

Hi, I am having trouble dealing with multiple arguments when they are passed from one cell to the next. I have the following public sub: Public Sub testFunctOne() Dim arg1, arg3 as Long, arg2, arg4 as Variant, arg5 as String arg1 = 10 arg2(1) = True arg2(2) = False arg3 = 10 arg4 (1)= 1...

Hello, all! I have a project that seems a little out of my league; so I figured who better to ask than the best! Okay... Explanation time. I need a formula to determine whether or not a well in my spreadsheet is elegible for compensation - just a TRUE or FALSE. Sounds easy enough, no? Wait for...

Hey guys, I am trying to motivate myself in anyway possible, I figured by creating an excel sheet and seeing some statistics might help, worth a shot. I would post a screen shot but it is way too hard. Anyways, I have a tab for data where I have a column with each date for the remainder of the...

In context, imagine you have a table with Columns (A) City, (B) State, and (C) Population. I'm familiar with arrays like this to return the population for each city/state combination: {=SUM(IF((CityA=$A$Column)*(StateB=$B$Column),$C$Column,"Error"))} When Columns A and B are unique...

Hi all, I'm excited about being a part of this board. I am an intermediate user with a problem I don't know for sure that can be solved. I think it can though. I have come close. Problem I have a list of data that looks like this. A............... B........ Start..... End <TABLE style="WIDTH...

I must be going about this in the wrong way so I need some help. I have come to this conclusion since 1) it is not working correctly, and 2) I can't find any other posts about this. I have built a userform with multiple input boxes. There are currently 6 rows of like data that can be entered...

I'm struggling to write a working formula that contains all the arguments below to return the correct result. IF D3 = "4" OR "8" AND G3 = "1" then "8DM11" IF D3 = "4" OR "8" AND G3 = "2" then "8DM21" IF D3 = "A" AND G3 = "1" then "8DM11" IF D3 = "A" AND G3 = "2" then "10NM1" Any help on this...

I have a spreadsheet that has a column A with a unique code per row, multiple codes in column A, i.e. misc, gasr, wter etc. Misc = Administration Fee wter = Water gasr = Gas In the same row I have a column B that has data like = "10/6/2010 - 11/4/2010 Due Date -12/5/2010" Based on the data...

I'm trying to write a formula to fill in data from one tab into another based on two conditions. (same spreadsheet file) If the data in C and D on the first sheet match the data in A and D (respectively) in the second sheet, I would like the data in H on the first sheet to be entered into G on...

Hello all - I'm dealing with a Worksheet_Change command in Excel 2003....Q: I don't think it's possible to have Multiple Worksheet_Change commands on same worksheet? >>>>Well....I get an error message so Im guessing not... How can i combine the following commands? 'this highlights rows that...

Hi Guys, Would love a wee hand with this: My data looks like this A B 1 0 1 1 1 2 1 0 2 4 2 4 2 0 2 5 3 1 3 5 3 0 3 2 3 4 What i want to do is that for each value in A, count the number of occurrences of values 1:5 in it's matched rows. Ideally i want to do something like this but i can't get...