# 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

I am looking for quantity sold of each item from specific dates, but the dates and quantity sold and order ID are on different pages, and there are multiple items on each order
Solved by O. L. in 14 mins
I'm trying to find the correct formula to link the Item # and Order Quantity on Excel spreadsheet to give the Total Quantity on a different Excel spreadsheet.
Solved by S. H. in 23 mins
In Cell B26 i need a v-look up and match formula to pull the figures from the Copy of Private June 2014 tab (D24:D28) depending on the input of the engine size in B16 of sheet 3. It should be set up like the formula used in B23 (sheet 3). For example if the engine size is 1500 or less the premium charged should be \$385 (D24 Copy). If the engines size is 2,200 or less but above 1500 the premium charged should be \$483 D25 Copy) and so forth. In addition is B39 the Loadings and or discounts should be added or subtracted accordingly from the base premium in B6.
Solved by G. J. in 20 mins
Hello, I am finetuning the data I collected for my thesis. I have 1 column in which a cell can take the value or 1, 2, 3, 4 or 5. I want to make a column next this one in which I want to put the condition that if a cell takes the value of 1 or 3 it must say No Strategy and on the other hand if the cell takes a value of 2, 4 or 5 it must say Use Response Strategy. I've been trying IF and OR formulas but it doesn't work. Please help me.
Solved by B. F. in 20 mins
I need to expand and contrast a table based on an entered value. I have number of years, revenue, cost, yearly total and deal total. Need the table to expand or contrast based on the amount of years the user puts in
Solved by O. W. in 14 mins
I'm just trying to write a function that combines AND and OR functions. Can you see what's wrong with this? =AND(C2<1,S2=OR("R02","R07","R08","R10"))
Solved by D. A. in 11 mins