Get instant live Excel expert help with IF AND Functions

use a countif, averageif and excel if else to calculate the number of breeds

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.

Hi, i need some help with writing a complex excel formula using a multiple if / if and / if or statement.

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.

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.

Greetings, I need help creating a sumIf and countif formula. Also need help interpreting the sheet. Will provide more information. Thanks!

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.

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.

How can I shorten my nested if and index match statements to be bale to run on a recorded macro?

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.