CAN SOMEBODY HELP ME WITH THIS MICROSOFT EXCEL FORMULA!!!!!!!!!!!!!!!!!!!!!!!...
Im taking a practice test and its asking me this question: Edit the formula in cell C2 so the references to cell B2 will update when the formula is copied, and the reference to cell B9 will remain constant. Please type your edits; do not click cells to reference them. I tried fixing it a bunch of times and still dont get what im doing wrong. This is the formula im suppose to edit: =B2+($B$2*B9) I tried changing it to how the lesson says but it still says I am wrong. If you think you can show me how to do it than PLEASE DO SO. Heres the lecture on what it says on how Im suppose to do it: Relative reference — A1 Absolute reference — $A$1 Mixed reference — $A1 Here's how relative and absolute references work: When you type a formula into a cell, it uses relative references by default. Excel calculates the position of the referenced cell relative to the active cell. For example, if cell B17 is the active cell, and you type the formula =B16, Excel displays the value of the cell that is up one row from the active cell. If you add another row to your worksheet, shifting the position of cell B17 to cell B18, Excel automatically adjusts the reference in the formula to reflect the new cell address that is up one row from the current position. If you copy the formula =B16 from cell B17 and paste it into cell C17, the pasted formula will update automatically to =C16 to reflect the cell address that is up one row from the new position. But what if you don't want the cell reference to adjust? For example, cell B13 contains a value that you want to use in calculations for multiple cells in a row. If you were to copy the formula =B13*B16 from cell B17 to cell C17, the formula would update to =C13*C16 (not what you intended) because both of the cell references are relative. Instead, you want the reference in cell B13 to be absolute, so it does not update when you copy it. If you use the formula =$B$13*B16 instead, and copy it from cell B17 to cell C17, the pasted formula will only update the relative reference (B16). The absolute reference ($B$13) will remain constant. The formula in cell C17 will be =$B$13*C16.
Which are the best forums for help on Microsoft Excel?
www.excelforum.com
Can someone help me create a formula on Excel?
On the Summary sheet, in cell B5, create a formula that will display the value from cell B9 on the Courthouse sheet. Use the same technique in cells B6 and B7 to place the Total Gross Pay values from the City Center and the Community Center sheets on the Summary sheet.
Can someone help me with fill colors on microsoft excel?
I'm not sure about the "lighter than 60%" part of it, but if you open the fill color dialogue box and it displays the color pallette, just let your cursor "hover" over the colors for a second and text will appear describing the color you are hovering over. On mine (Using Excel 2007), on the top most line, six over from the left, the text reads, "Red, Accent 2". Like I said, I don't know about the other half of your question, but hopefully that helps some!
I need some help on an excel formula. Can I ask it in here or can someone recommend a good forum or group to ask it in?
You asking permission to ask a question on a question asking platform where people ask all kinds of weird questions?Come on man. Chill.Ask the question.I work in Excel VBA as well as in Excel otherwise. So As far as good Excel forums are concerned, whenever I need some help, I just Google it and usually I find answer on some Excel forum. Sometimes it takes time and I have to change my search keywords but eventually I always find answers one way or the other.So I would suggest, ask questions here as well as Google.
Can someone help me with this PMT function in Microsoft Excel?
you are missing the number you have in G13. i guess i could take time to figure out whats in G13, but it doesnt matter much because....your formula looks ok. The only thing i would change is the "type"....thats the very last ,0 at the end of your formula....if the payment is made at the end of the period, then your ,0 is right....if the payment is made at the beginning of the period, then you want to change it to ,1 so try this (very similar) formula =PMT($B$6/$B$7,B8,G13,0,1) let me know how it works
Can someone help me with an Excel formula to calculate the most recent date from an array of data?
I would use a few cells for intermediate calculation steps, which you could hide later. For example in your example, you could type into C8 =MATCH($A8,A$2:A$6,0) and then use autofill to the right for all 31 dates and down for all products. This will create a table that has numbers whenever the product was found on the respective date and has #N/A in cells where the product wasn't found for that date. Then you can use the formula =INDEX(A$1:C$1,1,MATCH(0,C8:E8,-1)) into B8, which will lookup the most recent date for the respective product. You can also autofill this formula down for the other products. Make sure the values from B8 downwards are formatted as dates. To calculate correctly for all 31 dates you'll have to change the formula in B8 to something like =INDEX(A$1:AE$1,1,MATCH(0,C8:AG8,-1))
Microsoft excel baseball standings formula for winning percentage?
=games won/(games won + games lost)
How do I lock in a formula on MS Excel?
Open Microsoft Excel.Highlight the cell containing the formula you want to have changed into an absolute or relative reference.In the formula box as shown below, click the formula box or highlight the formula and press the F4 key to switch between an absolute and relative cell reference.If you want to write manually or create your own absolute reference, use the "$" symbol in your formula. Below is a basic example demonstrating the difference between a basic relative and absolute reference.Relative reference=SUM(A1:A3)Partial Absolute reference=SUM($A1:$A3)