Production rate (units/hr) Part 1 Part 2 Part 3 Cost (£/hr) Department 1 7 6 9 25.0 Department 2 6 11 5 12.5 One week, 1050 finished (assembled) products are needed (but up to 1200 can be produced if necessary). If department 1 has 100 working hours avai

This formula can replace all later formulas in this article except the formula to count the number of words in a cell. Example 1: Counting the Number of Occurrences of a Text String in a Range. Start Excel, and then open a new workbook. Type the following

Question: I have been looking at your Excel IF, AND and OR sections and found this very helpful, however I cannot find the right way to write a formula to express if C2 is either 1,2,3,4,5,6,7,8,9 and F2 is F and F3 is either D,F,B,L,R,C then give a value