I need help with excel formula?
I need help with excel formula. OT rate is 2x the amount of the normal rate but once 9 hours or greater are reached then 8 hours are 2x the amount the ninth and greater are 3x the amount of normal pay. hourly rate is $10.00 8.99 hrs over time get paid 179.80 (8.99x20.00) 9 hours OT get paid 8x20.00=160 plus 1x30.00=30.00 Total: 190.00 I need a formula that will show an amount up to 8.99 and if equal to or greater then 9 to show 8 and the rest in the next cell down if the original number is 9 like this example cell A2 should show 8 hours and cell A3 should show 1 hour If the original number is 6 then cell A2 should show 6 hours and cell A3 should show 0 hours is this possible? Actual rate is not 10.00. Simply used 10.00 for a simple example. In the image it may will show different numbers. OT starts after completing the 49th hour. First 48 hours are normal rate.
NEED QUICK HELP WITH EXCEL !!!!?
I'm working on an excel task as homework. I'm beginner to excel so I need some help with this question. It says : On the In cell O8 use a formula to display the word Yes if the athlete’s longest throw breaks the Olympic record or display the word No if it does not. (Remember that there are two records, one for men and one for women.) FILE:(ONLY 6.07KB) http://www.mediafire.com/?o54wmlzj21a9y0...
I need some help about EXCEL! ?
It makes a difference when you cut and paste, fill ranges, add rows or columns, and so on. If you put the $ in a formula before the column letter B, that is saying "I really mean column B" and not just the column to the right of this formula. A time that you would use this is if you have a number at the top of your spreadsheet (or any particular, non-moving place) that will be used throughout the table. Say you have an invoice that includes a chart with prices, and want a column that calculates price after sales tax. (The smart way would be to do a VLOOKUP table with the tax values, but I digress. Let's say for this answer that you only work on one state per invoice and don't mind putting the tax rate in when you begin each invoice.) If you will input the sales tax rate into cell C3, and have your prices keyed into in column D and want to calculate tax in column E, the column E formula for row 7 would be =D7*$c$3. You could then drag, fill, or copy that formula down the rest of the rows. When you do, the reference for the cell to find the tax rate won't change on every row, but the reference for the price will--the next row's column E formula would be D8*$c$3--using the dollar signs means it won't fill those cells with D8*c4.
Need some help with Excel Formula?
Hello, I'm doing an assessment for Computer Applications. One of the projects is with Excel. I was able to finish 90% of it, but now i'm stuck on one formula. I need to figure of the formula for the total value of inventory. For example: Cost per unit: $55.00; Amount on hand: 27; Value of Inventory: $1,485.00; Sales tax (0.06%): $89.10 Tariff: 0.08. Total Value of Inventory: ?. In that example the answer is $3148.28, but i have NO idea how they got that result. Any help would be ridiculously helpful. I've been stuck on this for almost a week now! Thank you sooo much!!
I am using Microsoft Excel... I need help.?
My mother is a high school teacher. I want to help her compute grades so I do the encoding and computation to a computer with MS Excel. It does really good. Has anybody among you know what a TRANSMUTATION TABLE is? It is a table that consist of transmuted numbers, for example, if you got your score to be 50 on a 70 item-test, then the transmutation table tells you that the transmuted grade is 85. Similar if 45 points in a 50 item test, it gives you 97. The problem is, I want to spend less time when doing this. How can I program MS Excel 2007, say, than whenever I prompt that the total test items, say is 80 and when I enter a specific digit, it will give a transmuted grade similar to what I had described? Because it is so hard to look on the table then put it on computer then look all over again. I hope you understand this. Sorry for wrong grammar if there is.
I need some help with an IF CONTAINS Excel Formula?
try =IF(ISERROR(FIND(1,A1)),"OTHER","ONE") hope that helps
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.
How can I get excel help right now?
Excel is known as a spreadsheet, nowadays which is widely used to make charts, identify trends, conditional formatting, calculations, and many more. So, we can accomplish lots of work under one software. To solve assignments related to Excel, it is important to have advanced ideas at every single field in excel. Due to many reasons, such as time issues, lack of knowledge, students can’t complete assignments accurately. So that, they can’t score satisfying marks in assignments as well.If you need help in excel to understand some topics, you can search it on Google or go for different video tutorials of Excel on YouTube. But to understand the topics precisely, you must need to have basic knowledge in Excel. On the internet, you can find solutions on the different type of problems related to Excel. You just need to search accurately to find answers to your exact queries.But, if your face problems to solve your excel homework assignments, or have the urgent deadline to complete certain assignments related to Excel, we are here to help you. We at Dream Assignment, provide the best assistance in writing and solving assignments on Excel. We have the team of experienced professionals, who are handling such challenging projects for many years; and all the assignments are credited as the best by the instructors; which they have delivered till now.So, if you have urgency in completing Excel homework assignments, or need to help with excel homework to achieve the top score, you must choose the best Excel homework help. Because you can get the best result only if you act at the best level. Thus, hire us and get the best excel help right now!Contact Details of Dream Assignment:Phone Number: +14235002312Email ID: info@dreamassignment.comWebsite: https://www.dreamassignment.com/...
Excel Code Formula Help?
I need a excel formula that will allow you to enter a numerical value in one column and a letter in the a second column. The equation would make a 1 A = 1.1, 1 B = 1.2, 1 C= 1.3, 2 A = 2.1, 2 B = 2.2 and so on. Any thoughts?
Help. I need some direction in Excel. How do I get started.?
Excel class project I just direction for one and I can do the rest. You work in the office of Johnson s Appliance Centre. Part of your job is to keep track of all pending sales orders and use this information to help salesmen get jobs on the Delivery Schedule as soon as all items needed for the order are in stock. This Excel file is kept on the company server so all salesmen (Rick, Doug, Steve and John) can access it. However, the salesmen are not fluent in Excel and have trouble filtering the data to show just the orders that they need to schedule. To assist the salesmen, create a macro for each of the four salesmen (Rick, Doug, Steve and John) that does the following: 1. Filters the list for their name in the salesmen column 2. Shows Yes in the All Items in Stock column 3.Sorts the results by Delivery Zone.