*google jobs sustainability*(eg a corresponding cell for F3 is G3). If all 5 cells have a value, the formula will return "Complete". Answer: You can write an IF statement that uses the AND function and the OR function as follows: IF(AND(C2 1,C2 9, Question:In Excel, I have a roadspeed of a car in m/s in cell A1 and a drop. Question:I'm looking for an Exel formula that says: If F3 is "H" and E3 is "H return 1 If F3 is "A" and E3 is "A return 2 If F3 is "d" and E3 is "d return 3 Appreciate if you can help. The IF function is performed in another cell altogether. Answer:This Excel formula can be created using the AND formula in combination with the IF function: We've defaulted the formula to return a blank if none of the conditions above are met. The OR function below uses the greater than operator. As a worksheet function, the IF function can be entered as part of a formula in a cell of a worksheet. Try the following: Question:For an IF statement in Excel, I want to combine text and a value. Question:In Excel, I am trying to create a formula that will show the following: If column B Ross and column C 8 then in cell AB of that row I want it to show 2013. Answer:First of all, you might want to replace your OR

**if cell is greater than but less than**function with the AND function, so that your Excel IF formula looks like this: Next, make sure that you don't have any abnormal formatting in the cell that contains the results. Answer:To write your IF formula, you need to nest multiple IF functions together in combination with the AND function. I can automate A3 with the following IF function: IF(isblank(A2 booked out returned But what I cant get to work is if the product is out for 10 days or more, I would like the cell to say "send email" Can you assist?

## 0 Remarks