Excel Busn Math 15: Large Math Word Problem

Need help to create a formula that will, first multiply the value of two cells, then divide by 3600 & multiply the answer by a certain percentage depending on which range the answer falls into. eg.
If 2100 (A1) x 210 (B2) divided by 3600 falls between 1200 & 1400 then multiply by 110%, if answer falls between 1000 & 1200 then multiply by 112%, if answer falls between 900 & 1000 then multiply by 114%.
Thank you in advance for any assistance.

i have a sheet set up to give me certain formulas for our payroll tax. for instance,
these are the numbers that show in the columns, they seem to rounded up on their own when needed, which is what i want.

column c = gross = 270.00
column d = Fed 15% = 40.50
column e = SS 6.2% = 16.74
column f = mc 1.45% = 3.92
column g = State 6% = 16.20
column i = Net = 192.65

the problem is this: i have a "Totals" column so that I know how much to send to the IRS each month. It does not add the rounded up figures "shown" but adds the un-rounded figures some how. the problem is that over time these figures are coming up wrong.

for instance, the mc 1.45% column shown above is actually 3.915. after several of these columns, my figures are wrong. take a look.

Date: gross: mc 1.45% shown in cell mc 1.45% actual

3.1.07 1000.00 14.50 14.50
3.5.07 270.00 3.92 3.915
3.12.07 100.00 1.45 1.45
3.19.07 50.00 .73 .725
3.26.07 50.00 .73 .725

totals 21.32 21.315

it gets worse... if you add all of the "shown" mc column, it is actually 21.33

here is the formula i am using for the "Total MC 1.45%" cell =SUM(F3:F60) now i have another problem, i am suppose to match the s.s. tax and the medicare, so i have another cell that is suppose to simply multiply the "Total MC 1.45%" cell by 2. here is the formula i use for that cell. =K10*2 it says that 21.32 x 2 = 42.63 this is how i discovered this mess in the first place.

i hope this is understandable, as i know it's a bit hard to explain without seeing it. any help would be really great, as this is my first month to begin doing this and i need to get this thing right.

thanks in advance.

Here's the newest brain teaser:

I would like to be able to obtain round integers only from one number.

For instance, I want to be able to obtain the number
1,2,3,4,5,6,7,8,9,10 from the base number of 10.25

Sound like fun?

My only attempt thus far as I start this challenge is this:

=ROUND(A1*(((9/10)/10)*A1),0)

.... where A1 = 10.25 This will work out to 9 like I am attempting to
do, but has issues in that if the number (10.25) increases beyond 10.27
it rounds itself to 10, and beyond 10.5 it rounds to 10.5. Its a
problem with the 9/10's in there.

Consider this a puzzle and not so much an excel formula, though
knowledge in both is required... Im back to it....

I'm trying to get all of the possible combinations of 3 that cost less than $4 and their values in a list using an excell formula? Is it possible?

There are 7 things at the store and you must buy 3 different ones without spending more than $4. All 7 items are valued differently than their price. What 3 things would you buy to get the most value? Any money you save from the $4 gets added to the purchase's value.

Toy $2.00 - Value 4
Magazine $1.75 - Value 4
Ice Cream $1.50 - Value 3
Drink $1.25 - Value 3
Lotto $1.00 - Value 2
Candy $0.75 - Value 2
Newspaper $0.50 - Value 1

I can do the math, but I can't do it with excell to check my answer...

Toy, Newspaper, Candy - Cost $3.25 Value $7.75
Toy, Newspaper, Lotto - Cost $3.50 Value $7.50
Toy, Newspaper, Drink - $3.75 Value $8.25
Toy, Newspaper, Ice Cream - $4.00 Value $8.00
Toy, Candy, Lotto - $3.75 Value $8.25
Toy, Candy, Drink - $4.00 Value $9.00
Magazine, Newspaper, Candy - $3.00 Value $8.00
Magazine, Newspaper, Lotto - $3.25 Value $7.75
Magazine, Newspaper, Drink - $3.50 Value $8.50
Magazine, Newspaper, Ice Cream - $3.75 Value $8.25
Magazine, Candy, Lotto - $3.50 Value $8.50
Magazine, Candy, Drink - $ 3.75 Value $9.25
Magazine, Candy, Ice Cream - $4.00 Value $9.00
Magazine, Lotto, Drink - $4.00 Value $9.00
Ice Cream, Newspaper, Candy - $2.75 Value $7.25
Ice Cream, Newspaper, Lotto - $3.00 Value $7.00
Ice Cream, Newspaper, Drink - $3.25 Value $7.75
Ice Cream, Candy, Lotto - $3.25 Value $7.75
Ice Cream, Candy, Drink - $3.50 Value $8.50
Drink, Newspaper, Candy - $2.50 Value $7.50
Drink, Newspaper, Lotto - $2.75 Value $7.25
Drink, Candy, Lotto - $3.00 Value $8.00
Lotto, Newspaper, Candy - $2.25 Value $6.75

So, the answer is that even though it's possivle to spend the full $4 in a few different ways, you're actually best spending $3.75 on the Magazine, candy and drink in order to get the most value $9.25.

Simple enough with so few options, but the problem has the potential to help with the purchase decision when there are let's say 50 options, prices and values and 10 different items need to be purchased. If there is a way to solve it in excell I'd appreciate some ideas. Thanks!

Hello Folks,

This site has been a great help for me working in excel. I have an odd one here that I can't seem to figure out.

I need to solve this problem in excel.

I have a pool of money and I am going to buy apples. I get a base number of apples for free, the cost for each additional apple goes UP as I buy more apples. How do I calculate the total cost of the apples?

Here is the data I have.

I have a pool of $500

Apples cost:
1-5 = $5
6-10 = $10
11-15 = $15
16-20 = 20$
21-25 = $25
30+ = $30

The base # of free apples varies and is entered by the user.

Example:
Scott gets 9 free apples and takes and additional 11 apples, for a total of 20 apples. Scotts cost for the apples should be $185 ($10 for the 10th apple, $15 for each 11-15th apples and $20 each for the 16-20th apples).

How would I go about this one?

Thanks for your help!!

Hello all. I am new here so please excuse me if I screw up.

I am creating a bowling sheet for my bowling team. I got one free from a website, but I want to make some changes. When I make the necessary changes, I get errors. I hope someone can give me a little advice.

The program takes all of the games I've entered and keeps track of the games that have fallen within a set range. (one calculation will keep track of all of the 190-199 games bowled). The origonal program uses the formula:

=SUM(($D$4:$F$38>=190)*($D$4:$F$38=150)*($D$4:$F$38

I have created a graphed curve in excel based on data I have entered. I now want to take the formula for the graph, and use it as an excel computation where I can plug in X and get Y, or plug in Y to get X. However, when i try to enter in variations of these equations, I end up with just the wrong answers (based on the data that went into the graph to begin with.

The formulas excel gives me are these:

y = -1.1288x 3 + 23.209x 2 - 166.76x + 430.07 (preferred), or alternately


y = 579.38e -0.574x


So how can I enter this formula so that I can have it pull x from a cell and spit out the answer for y (and the reverse)?

adding 1 month to 30th january gives mar 2, why not feb 28th?
DATE(YEAR(C48),MONTH(C48)+1,DAY(C48))

how do i post a file here?

Hi Guys,

Can anyone help me on how to get the Annualized Data given the Year to Date data.

I dont know how to explain it.. But i think thats the simpliest explanation i can do.

Thanks and Regards,
Kabutops

Please help. Math is not my strong point

k31 and r31 are cells
majoraxis and sp1 are named variables