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.
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.
Annoying message when launching Excel...
Every time I launch Excel in Microsoft 365 I get the annoying message "Excel cannot open the file Book 9.xlxs because the file format or file format is not valid. Verify that the file extension matches the format of the file and that the file has not been corrupted." The Book number increments by one each time I launch Excel. Clicking on "OK" gets rid of the message, but the whole thing is still annoying.
