I am having a calculating issue with a formula I'm trying to use.
What I am trying to do is to multiply the " sum of one cell" with "another cell" for a total.
The following are the cells and data involved.
A12 = 93 C12 = $44.76
A19 = 93 C19 = =sum(C12*0.05) D19 = =sum(A19*C19)
The formulas looked pretty straight forward. My problem is the total I got in D19 was not what I calculated on a calculator. C19 is $2.24 and the above formula gave D19's total as $208.13 but the calculator's total is $208.32.
I can't figure out what is causing the different totals. If there is another formula I should use for this.
I have a spreadsheet where I need to multiply each field in a column by 1.015. However, I need each field to roundup by 2 if the mulitplication is less than 2. For an example, a field of 60 would only increase by .9 to 60.9 when mutliplied by 1.015, but I'd like it to display 62. I have attached the spreadsheet for review.
I want to multiply a number say, 1551 by 5%, 6%, 7%, 8% and 9% and round each result to 0 decimal places. Then the sum of these results (544)should be equal to 35% of 1551 rounded to 0 decimal places (543). How do I create an if function for rounding so that the sum equals 543.
So I have the first part of my equation and it works fine. The equation is in Column D.
=IF(ISERROR(FIND("Van",A7,1)),"",B7*C7+50)
What I want it to do is: Combine the above for Col D with: if the Unit Name Column (A) says anything EXCEPT Van, I want it to multiple Cost (Col B) by QTY (E) and put the total in Col D.
Condition 2 in the same cell. If the product of F2 multiplied by D2 is > E2 AND the sum of F2 and F1 multiplied by D2 is > 0, then add the product of D2 multiplied by the sum of F1 and F2 to E2, otherwise input E2
Condition 3 in the same cell. If the product of F2 multiplied D2 is < E2 BUT the sum of F2 and F1 multiplied by D2 is > 0, then input the product of D2 multiplied by the sum of F1 and F2.
Condition 4 in the same cell. If F2 < 0, and the sum of sum of F2 and F1 multiplied by D2 is < 0, then 0.
This is the best way I could think of the write out my intention. I think if I can get the above scenario into a one cell formula that should resolve my pain.
I have a complex request which I think can be done either via vb or a macro, not sure which is best?, will try to explain:
The table shows a list of items that make up various BOM. there are quantities of each item required at the different BOM level
0 = Top level 1 = Level Below 2 = Level below that etc, etc
If the top level (0) has a quantity greater than 1 then all the items at the lower levels should be multiplied by that quantity
THEN move to the level 1's and whatever the quntity is in the level 1 field, multiple all lower levels by that number if the quantity fields are blank, then always multipy below by 1
This needs to continue on down the chain of levels
So basically you end up with the correct quantites of each item at each BOM level.
I am looking for an excel formula that will allow me to perform the following logic: if a cell value in (M3:BA3)="D" then multiply C29 by the corresponding value in (M29:BA29), then sum all of the products.
I have Excel 2010. I am creating a spreadsheet for server backups. I have always been told to take the current size of the disk and multiply it by 10% to figure out the backup size needed for the backup. I am trying to create a formula to do this. I have a server with 25GB. The formula i tried was
=a1*10%. A1 being 25gb. Excel does not like the GB in the cell also this is only giving me the difference. I need to know what size to allow for my backup on this server.
I am having trouble with the final formula for this spreadsheet.
I want to be able to select "Holiday/Sunday" from the drop down men in column H, and have it multiply the total in column F by 2. There is already a formula in column F that sums column E-D.
I am having a little trouble with multiplying a few formulas. I am looking for a formula that will multiply the last three cells in a row that contain data and subtract 1. Below is an example of the type of data I am working with and the formula I am trying to use but is not working. The formula is for the cell highlighted in red. Every quarter the last three cells being referenced will change.....
I am trying to do is have the roundup formula round up the result of a more complex formula BUT do it all inside of the same cell? The formula I have is in cell A1 and currently I have to have the cell that contains the round up formula (in cell A2) and have it reference A1. The complex formula is =((280283.47/798186.89)*(700*20*4)) and the result is -19,664.41 which I want to round up to $20,000. Is there a way to make this all occur in just cell A2 or am I stretching it?
I am using Excel as my payroll spreadsheet A....name B....rate of pay C....date of work D....date of work E...date paid F....# of hours worked G....vacation hours H....Gross Pay....B7*(F7+G7) I....Net Pay....H7-J7-K7-L7-M7-N7 J....FICA....H7*6.2% K....Federal....no formula L....State.....no formula M...Medicare....H7*1.45% N....duductions....no formula O....OT...no formula P....Paid OT....O7*15.75 Q....Blank R....FICA MATCH....J7*2 S....Medicare MATCH....M7*2 (ISN'T ROUNDING UP OR DOWN PROPERLY)
For Instance.......Joe worked 19.58 hours at $8.50 = $166.43 gross federal is $0 state os $0 fica is $10.32 medicare is $2.41 R...FICA Match is $20.64 S...Medicare Match is $4.83.....(SHOULD BE $4.82)
Sorry but I didn't know how to properly explain the problem that I am having. The problem is in the rounding. Sometimes it doesn't round up and sometimes it doesn't round down.
number for item detail level from category standpoint. For example, in the category sheet has total number per category and per month and in the item detail sheet has a list of item number with category. I want a formula to recognize which item belongs to which category then use the total number of category by month to multiply with % of total in column D from Item Detail Spreadsheet.
if a cell contains character A THEN multiply by cell B * 0.02,if a cell contains character B THEN multiply by cell B * 0.05,if a cell contains character C THEN multiply by cell B * 0.010
I don't know if there is a setting I'm missing or I'm going mad but when I use the round function in VBA it doesn't round.
I am using Excel 2000. See the example attached.
In the cell A2 I have a value 0.525, cell B2 has a formula "=round(A2,2)" which = 0.53, but cell C2 is assigned via VBA ie Sheet1.Cells(2, 3).Value = Round(Sheet1.Cells(2, 1).Value, 2)
I am having trouble creating a formaula to calculate value based on the sum of a cell. For example if the sum of cell A1 is <= 149 I need to multiply the sum by 1.0 if the sum of cell A1 is 150-199 I need to multiply the sum by 1.50, if the sum of cell A1 is 200-249 I need to multiply the sum by 1.75, and if the sum of A1 is >= to 250 I need to multiply the sum by 2.00
I want to be able to enter a value into a cell (within a specified range if necessary) and have it automatically multiply by a set value and overwrite the original entry with the result so making it all happen within one cell.
After ripping a .pdf report into Excel I am left with a variety of items in Column A, numbers as text, text, and blanks. I manually selected entire column and paste special multiply. Seems to have convereted blanks to zero, converted numbers stores as text to numbers, and ignored any text. Problem is writing macro to repeat the steps as will use the tool every period. I tried looping through the range
For Each C In myRange C.Value = C.Value * 1 Next C
But this returns type mismatch error. So why did it work manually if won't work through the macro?
I need the code for a macro that, with a selection, it multiplies the cell number by “x” amount, keeping the original cell format. I know I can do that using paste special but I prefer a macro to be able to use it on different spreadsheets.
