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
I need to add additional criteria to IF AND OR statement.
Solved by E. Y. in 28 mins
Using named ranges, create a formula in cell H4 to display YES in the cell if either the number of clams is greater than two or in the current deductible is less than $1000.00, otherwise, display NO in the cell. Hint use a nestedIF and OR function.
Solved by M. H. in 17 mins
Hi, I have a formula on Google Sheet - Tab labeled 'LA - Fulfillment Manifest' Cell C10 that sums raw data from the tab 'Raw Dat' based on a set of criteria (Line Item Sku matches) and Order date/time is before and after a certain time. My formula was working but then my boyfriend made some changes and now it's not working anymore. Can you check the formula and fix please?
Solved by M. F. in 28 mins
I am trying to make a macro which takes data from 5 of 10 cells formatted 2x5 (the data is in the 2nd column) and organizes it into a table. I then want to be able to change the data in the column and use the same macro to insert the new data into the next row down on the table. What I am doing seems to be right however each time i use the macro I have created, whilst the new data goes to the next row down it also shift left (C2 goes to C1)
Solved by I. Q. in 30 mins