# 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

On the Sales Data by Agent worksheet, enter a nested IF and AND function in cell H9 of the Bonus column to display the bonus percentage. If the employee is international and sold over \$200,000 they receive 5% bonus (found in cell A4), all other employees receive 3% (found in cell A3).
Solved by I. S. in 20 mins
please do not try to solve this if you have no idea how VBA and functions work. I've now spent a lot of time with experts who have no clue how things work. The problem is calculating distance between two cells while using a function. Can you help with vba else if?
Solved by F. D. in 21 mins
please do not try to solve this if you have no idea how VBA and functions work. I've now spent a lot of time with experts who have no clue how things work. The problem is calculating distance between two cells while using a function and how to apply vbscript else if. I have almost ready function that needs just a little push to make it work as it should!
Solved by C. C. in 19 mins
In cell D34, use a logical function (AND) to determine if two conditions exist simultaneously. The AND function allows you to run two logical tests at the same time in order to see if both are true. You want to identify when soup was the lunch entree and salad was the lunch vegetable.
Solved by I. B. in 18 mins
I'm having trouble working with time in excel. I know the start-time and end-time of an event. For example, start=2:20 AM and end=10:23 AM. I need to parse the total time (in minutes) into "time buckets." The time buckets are: 7am-3pm, 3pm-5pm, 5pm-7pm, and 7pm-7am. I using the IF and AND() functions, but things get complicated when crossing over from am to pm.
Solved by V. F. in 16 mins
Please can you help with IF and AND functions to assign number basis master to sheet 1
Solved by D. H. in 25 mins
Please look at the formula used in cell A2, A3, and A4. I duplicated that formula into cells B23 and B24 When you type in a value that is equal to cells D1:I1, in cell A1 it will copy the cells under that value into cells A2:A4. (Example: Type in "check" in A1 and it will populate "A"into cell A2, and "B" into cell A3, and "C" into celll A4.) If I tpye "SL100PARLIST" into cell B22 it SHOULD populate "N/A" into cell B23, but it doesn't. The formula works in cell A2 but doesn't work in cell B23. What am I doing wrong? The person who made the formula in cell A2 used an array, I don't believe this is used in cell B23. Could you please help me get the formula in cell B23 to work and function just the formula in cell A2? I want it so when I type a name in B22 that matches a name in cells M23-AW23, it will copy the cells under that cell into cells B24-B33. Does this make sense? Thank you so much for any help you can send my way :)
Solved by F. C. in 27 mins
I have a small table as such: Power Interest Result Low Low Monitor High Low Keep Satisfied Low High Keep informed High High Manage Closely When a user selects a power level and an interest level in separate columns, I want it to return the result in the 3rd columns. I am getting very frustrated with IF(AND functions not working for me! Thank you!
Solved by O. H. in 13 mins
In cell H6 I need help entering an IF function with a nested AND function to analyze the content of F6 and G6. Return Complete if both cells contain a Y or Incomplete if one or both cells contain a N
Solved by X. J. in 23 mins
Stuck on this problem, Am not sure exactly what I am doing wrong. Any help would be greatly appreciated. Thank you In cell C25, use the AND function to determine whether the Entertainment total is less than \$200.00 and the MIsc. total is less than \$100.00.
Solved by G. Q. in 25 mins