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

9. Switch to the Employee Summary worksheet and calculate the totals in the table using the appropriate functions. HINT: Remember that sumif multiple criteria adds or totals cells only if they meet the specified criteria, and AVERAGEIF and COUNTIF perform their computations only when the data meets multiple criteria.
Solved by T. C. in 11 mins
Hello, I need to figure out how to link a cell in one sheet to a cell in another sheet, but those cells need to link if and only if they have the same part number in a different cell how do I do this?
Solved by A. U. in 15 mins
I need help with an IF AND formula that will place a number/mark in each cell if the time is between two different hours AND also place an L for lunch intervals, and B for break intervals. This will be on a 15-min interval. Formula is in attached file starting in column DT5
Solved by K. F. in 20 mins
I need a IF and IFERROR formula for column H.
Solved by C. Y. in 20 mins
Hi I have column of registered attendees to an event and then a second column of actual attendees. i need to be able to identify what attendees attended and those that didnt. i have tried applying conditinal formatting but it does not account for any variations in fonts or spacing. i also tried IF and Vlookups but i cant get anything to work.
Solved by B. E. in 15 mins
I need help to get rid of #DIV/0! in a spreadsheet where I am using the following formula: =AVERAGE(DF34,DI34,DL34,DO34,DR34,DU34,DX34) If there are no numbers in the specified cells, this formula is returning the value of #DIV/0! and I would like to have it either be 0 or blank. I have tried the IF and IFERROR function but am not placing this IF formula in the correct position to the =AVERAGE function. Please HELP!!
Solved by T. Q. in 22 mins
I need help with if and statement excel I am unable to apply it
Solved by O. F. in 23 mins
Hey Guys, I have a problem. In my database, i have several injuries mentioned (eg.: head,half-head, nose, finger, hand, torso...), all injuries are written down in one cell. Most of the time, the medical personal writes down all parts of the body mentioned. I wand to find out, how many injuries in a special group of injuries have been attended within this year. Group 1: head, nose, eyes... Group 2: hand, finger, arm... With countif and sumproduct i only get the number per injury. How can i avoid double-counting? E.g. there are 25 injuries on half-head and 31 on head. (6 whole head + 25 half-head)... Thanks in advance!
Solved by C. B. in 30 mins
I need a formula that will perform MIN on a specific region. I have a FID that is the name of my series of data. I want to perform a MIN only on the data that corresponds to the text in column FID. Using IF and MINIF, this is complicated and gives very big formulas. I show an example in column G (headers:Y) of the calculation I want to perform. I need a less complicated formula.
Solved by E. F. in 12 mins
Using named ranges, create a formula in cell G4 to display YES if the number of at-fault claims is greater than one and the current rating is greater than two.Both conditions must test true to display YES; otherwise display NO in the cell. Hint: Use a nested IF and AND formula.
Solved by X. H. in 20 mins