Excel Busn Math 45: Trade Discount Word Problem

Hello

I have a list of WHSL prices with 10% discount. What formula can I run to get the original price?

The algebra would be x*.9=(cell value)

Thanks!

Greetings! Hope someone can help.

Formula or VBA welcome.

See attachment.

I want to calculate the P/L (profit and loss) of each trade. This can easily be accomplished by calculating the difference of the "NET Amt". But each trade has it's own "Trade #"; this serves to 'group' the trade together.

Each of the trades can have multiple B(uys) and S(ells). In addition besides Long(L) trades there are Short(T) trades.

Ideally, the P/L amount should appear at the most bottom row?

Your very welcome to make suggestions as to the overall of the worksheet.
I want to maintain the "row" type appearance.


Sample data:
TRADE # L/T B/S Ticker Shares Price Gross Amt SEC COMM SETL NETAmt P/L 110324NEWCA1 L B NCT 1,000 6.00000 -6,000.00 0.00 10.00 -6,010.00
110324NEWCA1 L B NCT 5,000 6.00000 -30,000.00 0.00 10.00 -30,010.00
110324NEWCA1 L S NCT 6,000 6.04000 36,240.00 0.70 30.00 10.00 36,200.00
110324HYPER1 L B HDY 5,100 6.28560 -32,056.56 25.50 10.00 -32,092.06
110324HYPER1 L S HDY 5,100 6.34570 32,363.07 0.62 25.50 10.00 32,326.95
110324GULFP1 T S GPOR 3,000 32.61900 97,857.00 1.88 15.00 10.00 97,830.12
110324GULFP1 T B GPOR 3,000 32.59520 -97,785.60 15.00 10.00 -97,810.60

NOTE: EACH NEW TRADE GETS THE SAME "TRADE #" FOR EACH B AND S OF THAT TICKER
THE NUMBER OF B AND S CAN BE UNLIMITED
THERE ARE LONG AND SHORT POSITIONS

LEGEND:
L=long position
T=short position
B=Buy
S=Sell

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....

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!!

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 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

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?

I have a Word doc that I would like to load into Excel (or Access, if needs be) word by word. So if the Word doc has 500 words spread over 50 lines and two pages, I would like the 500 words to appear in cells A1 through A500, one word per cell.

Any ideas? I'm not quite sure how to do it, but perhaps if I could feed each word in Microsoft Word into an Array, then I could have the Array be output in Excel.

Any suggestions would be appreciated. Thank you.

Jared