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

use a countif, averageif and excel if else to calculate the number of breeds
Solved by A. J. in 16 mins
create a formula using the IF and VLOOKUP functions to calculate the rental charges for each set of furniture based on the furniture’s group code, the rental period and the Furniture Rental Charges table,For the IF function arguments, use one VLOOKUP function for the 6-months and another VLOOKUP function for the 12-months alson column I, enter a formula to calculate the insurance charge if the renter has elected insurance coverage. Use the furniture’s group code and the Monthly Insurance column in the RentalCharges table to look up the insurance charge. If the renter has not elected insurance, the cost is $0.
Solved by F. H. in 16 mins
Hi, i need some help with writing a complex excel formula using a multiple if / if and / if or statement.
Solved by B. A. in 11 mins
need a formula that has an if and vlookup function, have a unique id in both sheets, i want a formula to lookup a certain cell in sheet 2 and if the unique ids match in both sheets, the formula shoud say found.
Solved by E. E. in 30 mins
Hey, If i have a cell range for foreg: a1:a100 and b1:b100 and i want to know if a1+b1=7 for each row and get the countif value that total 26 cells return with a total of 7. How can i get that done in excel or google sheets. I have tried the countif and cointifs command with multiple columns but don't know how to get them to add/substract with each other. Also how to apply if and google sheets? Thanks.
Solved by B. W. in 22 mins
Greetings, I need help creating a sumIf and countif formula. Also need help interpreting the sheet. Will provide more information. Thanks!
Solved by F. H. in 12 mins
I am trying to use nested IF and lookup commands to create multiple outputs from a series of 3 drop down menus. For example: If drop down menu options are A, B, and C then the result will be 0.1 but if it's A, C, C, then the result will be 0. It's sort of a calculation chart/generator type thing.
Solved by Z. A. in 15 mins
Hello, I am trying to combine an IF and VLOOKUP formula. I am trying to build an invoice sheet and I want to make it so if there is no code in the Product code space then Product name, description and unit price will be blank. After researching I found this =IF(ISNA(VLOOKUP(A20,Poducts,2,FALSE)),"",VLOOKUP(A20,Products,2,FALSE)) But it is not working as the N/A does not dissapear from the spaces with no codes. In my workbook I have a sheet called clients, products and Invoice with the tables carrying the same names for referring Vlookup. Any help is appreciated.
Solved by T. L. in 25 mins
How can I shorten my nested if and index match statements to be bale to run on a recorded macro?
Solved by T. C. in 28 mins
Talent Tracs pays three levels of employee bonuses. Each bonus is based on the employee’s pay grade, which is a system Talent Tracs used to group jobs based on difficulty and responsibility. Use a nested IF and the information provided in Cells W3:Y5 to calculate each employee’s bonus. HINT: Anyone with a pay grade of 3 or higher earns a $7,500 bonus. Format the cells in the Bonus column with Currency style and ZERO decimal places.
Solved by G. U. in 16 mins