if fuction

Hi! I have a list of account numbers, if they match the list of $0 admin fee list on another sheet, I would like it to equal 0 but if not, 10. I have =IF(B2='$0 admin sheet'!$A$1:$A$1783,0,10). Thank you in advanced!!!!

I need help putting together an IF(AND( formula that allows for multiple ranges. ...............1ST 2ND 3-5 6-10 3 X 5 ..... $100 $60 $35 $30 FOR 3-5 I tried: IF(AND(A76="3X5",B76>=3,B76<=5),((B76-2)*35)+160) which worked! But when I tried the second...

I need help putting together an IF(AND( formula that allows for multiple ranges. 1ST 2ND 3-5 6-10 3 X 5 ..... $100 $60 $35 $30 FOR 3-5 I tried: IF(AND(A76="3X5",B76>=3,B76<=5),((B76-2)*35)+160) which worked! But when I tried the second range 6-10 it said...

Hello! I am hoping someone can help me. Basically, I am trying to have a percentage populate based on the number within a cell. I run into issues with the multiple arguments. This is what I am trying to accomplish... Anything less than 57000 = 5% Greater than 57001 but less than 84000 = 4%...

I have a column of totals that I need to multiply by different numbers based on their value. Units that sold $1 to $4,999 in 2015 and increase sales by 20% Units that sold $5,000 to $9,999 in 2015 and increase sales by 15% Units that sold $10,000+ in 2015 and increase sales by 10% I really...

So in general we are trying to calculate commission. I make 2% on anything thats is 15000 and less. Once I hit 15001 I make 5% on that. I cannot figure out the correct formula for the following. trying to figure out commission B3 = 16000 I need a formula thats tells me if B3 is less than or...

Hi, I have a workbook with multiple worksheets and I am struggling to link some of the data so I can review different bits of data on a single sheet. I have run 6 reports and used pivot tables to combine the data into a single worksheet named project summary to evaluate project to project...

Hello everyone, is there any possible way to set up a macro that will delete rows that were returned as blank from a function? I am putting together a book database and I want to have separate sheets for languages, genres etc. I decided to create a "General" sheet for all the info and then use...

I want to fetch the least value for 1 and 2, but I also want to fetch year associate with that minimum value. 1 2000 0.01 1 1 2001 0.00 2 1 2002 0.04 1 2003 0.09 1 2004 0.04 1 2005 0.06 2 2000 2.01 2 2001 3.00 2...