Login


03192007, 01:09 PM  #1 
Major
30
Rep 1,208
Posts 
Ms excel knowers PLEASE HELP.
Quick question hope you guys can help! Example:
A2 is empty... So when i put a number in their i want the other colomn to give me the answer to this 5%X5%30... SO i put it in but it get a bunch of jiberish. When i do it in my calculater it's correct but on EXCEL it's wrong. Can someone please tell me how to right it in the box. Here is exactly what i put under the the box 3A. =A25%*55%30 <THat's what i'm putting in. IN A2 i have 1000. the answer in A2 should read, 519.97, but it's giving me another number because i think i need to add parenthesees or something please help. i got the =a2 part but that's about it. So pretty much what i want is, whatever is in a1 to subtract5% then multiply it by 55% and subract 30. Please HELP!
__________________

03192007, 01:18 PM  #3 
Private First Class
7
Rep 137
Posts 
type this exactly how it's displayed below into cell A3
=(((A25%)*55%)30) Make sure cell A3 is being displayed in number format. The way to check for that is to put the cursor on A3 and then go along the top and select "format cellsnumber tabnumber" you should get 519.97 if the value in cell A2 is 1000. 
Appreciate
0

03192007, 02:54 PM  #4 
Major
30
Rep 1,208
Posts 
aGOT IT!!!!!!!!
Nikki and Nitz99 THANK YOU GREATLY!!!! i REALLY appriciate this. Thank you!
__________________

Appreciate
0

03192007, 02:55 PM  #5 
Major
30
Rep 1,208
Posts 
I followed what both of you have posted and tested it out and it worked! Thanks
__________________

Appreciate
0

03202007, 07:30 PM  #6 
Major
30
Rep 1,208
Posts 
Ok sorry. I did it and even though you guys were correct it's not giving me the numbers i'm looking for simply because i believe i have to organise it differently. Pretty much here is the example number i want to use with the answer. please help me figure out how to word it out to get this answer.
EXAMPLE: 70005%(350)=$6,650.00 $6,650.00*55%=3657.50 30.00= ANSWER $3,627.50 Hope this is understandable. If you guys organize the work as you did (correct way) my answer would be what i got before, but i guess i'm looking for this type of answer. What would be the forumla. Sorry to bother.
__________________

Appreciate
0

03202007, 07:40 PM  #7  
Major General
201
Rep 7,953
Posts 
Quote:
therefore your ANSWER should be = $3810.375 using this formula: =(((7000(0.05*350))*0.55)30) [hint: 0.05 = 5% and 0.55 = 55%]
__________________


Appreciate
0

03202007, 07:49 PM  #8 
Major
30
Rep 1,208
Posts 
I know that. I mean that 7000 Minus by 5% is supposed to be 6650. The way i got that is. 5% of 7000 is 350. So if 350 is 5% of 7000 then i want to subtract 350 from 7000. I didn't mean 5% of 350. I used the () to let you know that 5% of 7000 is 350.
So in other words: 7000350 =$6,650.00..... Because 350 is 5% of 7000. $6,650.00*55%=3657.50 30.00= ANSWER $3,627.50 So that is why i would like a formula to give me 7000 MINUS 5% EQUALS ANSWER.... and ANSWER to be MULTIPLIED by 55% and MINUS 30 to give me that 3,627.50 i have up their.
__________________

Appreciate
0

03202007, 07:50 PM  #9 
Major
30
Rep 1,208
Posts 
sorry to bother but i really would like help on this topic
__________________

Appreciate
0

03202007, 08:26 PM  #10 
Major
30
Rep 1,208
Posts 
anyone?... BTW the cap letter were not used as raised voice.
__________________

Appreciate
0

03202007, 09:12 PM  #11 
Major
30
Rep 1,208
Posts 
ok so far i got half way thru.
7000(7000*5%) So far that gave me the answer of 6650 which is 5% of 7000. Now all i need to do is somehow multiply the total (6650) by 55% and minus 30 to give me the total of 3627.50. But when i multiply by 55% it gives me an error!
__________________

Appreciate
0

03202007, 09:24 PM  #12 
First Lieutenant
15
Rep 374
Posts
Drives: '05 645Ci Coupe
Join Date: Oct 2005
Location: Titusville, FLA

If it were me I'd do it like this =+((A2*0.95)*0.55)30

Appreciate
0

03202007, 10:32 PM  #13 
Major
30
Rep 1,208
Posts 
you what?..... I broke my FREAKEN brain to get it... I called my girlfriend and she goes...??? Just do _____*.95*.5530.... and i though... WTF YOUR STUPID IT'S NOT THAT EASY!!!.. then i typed it in... And walla.... SHe's fucking right...
Hours doing this shit... And now i look at my email and see you posted exactly what my girl stated... LOL... Man I really appriciate it bro. seriously i was breaking my head getting that done. Thank you for your help. I now figured it out. Now i can go to finish it and continue reading e92 posts Thanks!
__________________

Appreciate
0

03202007, 11:29 PM  #14 
Shadow Warrior
51
Rep 2,096
Posts 
Now you gotta treat your gf to something nice :P
__________________
335i E90 / Arctic / Gray / Burl Walnut / Steptronic / ZPP / ZSP / Paddles / CA / Nav / PDC / OEM Spoiler
Mods: PIAA Angel Eyes, Rear Fog Switch, Escort X50 Blue hardwire, 30% Charcoal Llumar Installing soon: Rear Power Outlets (Happy Robot mod!) 
Appreciate
0

Post Reply 
Bookmarks 
Thread Tools  Search this Thread 

