Forum Widgets
Latest Discussions
Count how many pairs of dice sum >= 7?
Please help me help someone in another forum. The problem: if we toss a pair of dice (6-sided), what is the probability that their sum is 7 or more? As I demonstrate below, the answer comes down to enumerating and counting the number of pairs with sum >= 7. Then, the probability is (#paired sums >= 7) / #pairs, where #pairs is #sides^2. (The answer is 21/36 = 7/12.) My question is: is there a formula that calculates #paired sums >= 7 without doing the enumeration manually or relying on VBA? I'm guessing that we can use Excel 365 features such as LAMBDA etc. But I know nothing of those features. And less importantly, for my benefit, is there an Excel 2010 formula, without relying on VBA? My "manual" solution:Finding a Commission with the IF Function
I am having trouble with the IF function in a project I am working on in a course. The instructions say, "In the first cell under the heading Commission, create an IF formula that checks if the sales amount on that row is greater than or equal to the target. If it is, the IF formula should calculate the commission due using the named cell. If the target is not met, the IF formula should return the value zero." I have tried typing in: =IF(F2>=G2,"Yes","No") but I am sure that is incorrect because it just tells me that the value is not greater than or equal to. Someone had suggested to put F2*10% instead of "yes", but what should I put for "No"? I have also been told that maybe I need to name a cell, "Commission" or "ComissionRate" where it would contain the value used to calculate the commission with this formula: =IF(F2>=G2,F2*Commission,0). I need to get the commission due. I am unsure of what cell to rename. Perhaps the cell with 10% in it? I have a sample worksheet and an image of what the final sheet should look like for reference: My sheet: https://docs.google.com/spreadsheets/d/124Iv3UvVtQECoKHIFGOzsI2d7H_oJjATaJmYEeMtStw/edit?usp=drive_link If anyone can assist me with this, I will greatly appreciate it. Thank you!
Need a formula to count unique values from one column based off of another column
Hello! This question is for a web-based Excel which I understand does not have all of the same features as a desktop Excel. I need to create a formula that counts unique values in one column (say, column O) based off of values in another column (say, column B). I currently have a working countif function as =countif($O:$O), A3), where A3 is the value to look for (in this case). Column O will have repeating values such as Waiting, Pending, Approved. Column B will have repeating values such as Customer A, Customer B, Customer C. As an example, I want to find out how many customers have a status of Waiting but I only want that status to be counted once per customer. So if Customer A has 5 rows with a status of Waiting, I only want it to be counted once. Thanks in advance for any help you can provide.Excel Calendar
I am trying to create a calendar that will update content on dates based on what is entered into a separate table. I have a drop down to select month and year, and a separate table with 3 headers, two of which I would like to appear on the calendar. I am using the following formula to create the calendar: =SEQUENCE(6, 7, DATE(C3, MONTH(DATEVALUE(B3 & " 1")), 1) - WEEKDAY(DATE(C3, MONTH(DATEVALUE(B3 & " 1")), 1), 1) + 1, 1) Along with conditional formatting for the dates. Any feedback on how to do this would be greatly appreciated. J3-L3 are headers for the table (Name, Due Date, Notes) I need content Name and Notes to appear on the corresponding date in the calendar (due date). B3 is the drop down for month, and C3 is the drop down for year. The calendar starts at B6 (days of the weeks listed B5-H5).
Formula
I have a warehouse inventory list that I am working on. I have a warehouse inventory sheet, purchase sheet and an order sheet. I have item numbers for the warehouse products. I need the total cost of the item number purchases/by total quantity from the purchase sheet to give me the average cost. The average cost will be placed on the warehouse inventory and the order sheet. I believe the formula begins with sumif(), but I am not sure. Any guidance on this question is appreciated. Thank you
Several Problems with latest spreadsheet
I have been using Excel for a while. My latest spread sheet is having several problems, probably related. Numbers in the sheet do not appear in the formula bar Going along with this, the autosum does not add up a column and the formula also does not appear up top Thank you for any help. Probably something simple I did on the sheet. Fred
Compare two workbook and return the cell value
Hi, I've two sheets with the following structure: Sheet1 (Main) has columns A (Last Name), B (First Name), and C (Email); Sheet2 has columns A (Last Name), B (First Name), and C (Email). I used the formula =IFERROR(IF(MATCH(A1, lookup_array, 0), "Yes"), "No") to find mismatching values between these two sheets. Now, I'd like to improve it to return me the cell values in the column C (Email) from Sheet2 to Sheet1 in column D (Good Email) if there is a match on columns A or B.
