 # Get instant live Excel expert help with IF AND Functions “My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

AllCare offers a 3.2% (ACDiscount) discount on items when more than three units are ordered at one time. In column F, use a nested IF and AND formula and the named ranges (Supplier, ACDiscount, UnitPrice, NumToOrder) to calculate the discount for each of the supplies listed. If no discount is given, place a zero (0). Format the numbers in the column to display two digits past the decimal point. Note: Use all lowercase letters when typing the formula.
Solved by F. A. in 23 mins
I have a formula using IF and AND... if a1=b1 and c1=c2 +/-10, "T","F" Im not sure about the +/-? thanks
Solved by M. E. in 18 mins
I am using if and large function to sequentially arrange the values. If I change the value of one item then the entire sequence is changing. I just want to replace the changed value without changing the sequence.
Solved by D. J. in 28 mins
I am working on a cash flow projection. Part of the projection includes sales commissions. Our sales guys earn a monthly draw and then commission on sales after a certain amount. For example they may earn a monthly salary of 12,500 and earn additional commission after their commission equals \$150,000. What I need excel to do is sum a column if the values in the preceeding columns are greater than \$150,000. I've tried using the sumif and the if function in excel and it's not working correctly either way. Any suggestions?
Solved by G. W. in 19 mins
Can someone review my my formula logic in the yellow cells? It's pretty self explanatory, just IF and COUNT functions sorting data. Let me know if you have any questions!
Solved by E. L. in 30 mins
Need formula to determine the appropriate answer from at least one chart when multiple conditions are met. I've been trying IF and vlookup formula's, but have not had success yet. please help.
Solved by B. J. in 30 mins
Hello. I am looking to create a running balance in a column on an excel spreadsheet, however I only want the balance to be calculated when the cells to be considered are not blank. I have tried sumif and sumifs but can't get either to work. This is what I am trying to achieve: Opening Balance C1 Debit A2 Credit B2 New Balance C2 = C1 + A2 - B2 (but only if A2 and B2 are not blank).
Solved by V. Q. in 23 mins
Hello. I am looking to create a running balance in a column on an excel spreadsheet for an accounting bank statement, however I only want the balance to be calculated when the cells to be considered are not blank. I have tried sumif and sumifs but can't get either to work. This is what I am trying to achieve: Opening Balance C2 + Debit A3 - Credit B3 New Balance C3 = C2 + A3 - B3 (but only if A3 and B3 are not blank, if they are blank then the balance for that row to be left blank too).
Solved by K. H. in 21 mins
A formula is not working, I think it should be IF and AND working together?
Solved by F. A. in 27 mins
I need a formula that adds up 3 columns with a criteria in a 4th column, I've used sumif and sumproduct but can't get it
Solved by V. A. in 28 mins