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.
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:
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
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.
Fill Series with varying data
Is there anyway to fill a series when the data varies in column, I have to drag each value down and copy/fill, I would love it if there was a way to copy the series down, for example. Grab all the cells and copy down 3630-301 into the next cell, but then 3630-302 into the 2 cells below that, 3630-304 into the next 6 cells below that and so on, if anyone has any thoughts.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!
Adding a formula to a column and make it auto-repetitive and deactivate the column
Hi Guys, I want to add a formula to the column to the first cell, and then to be repeated for each new row, knowing that I want to disable this column because it is calculated and I do not want the user to change it. In addition, I still want the end-user to change other columns.
