BMW M3 Forum (E90 E92)

BMW Garage BMW Meets Register Search Today's Posts Mark Forums Read


Go Back   M3Post - BMW M3 Forum > BIMMERPOST Universal Forums > Off-Topic Discussions Board
 
Steve Thomas BMW
Post Reply
 
Thread Tools Search this Thread
      03-19-2007, 12:09 PM   #1
billmister
Major
 
billmister's Avatar
 
Drives: e92 335i
Join Date: Nov 2006
Location: NJ

Posts: 1,211
iTrader: (1)

Send a message via AIM to billmister
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.

=A2-5%*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!
billmister is offline   United_States
0
Reply With Quote
      03-19-2007, 12:16 PM   #2
Nikki
Major General
 
Nikki's Avatar
 
Drives: del Sol VTEC
Join Date: Aug 2005
Location: OC

Posts: 6,369
iTrader: (9)

= ((A2-5%)*(55%))-30

did you try that?
__________________
Nikki

Nikki is offline   United_States
0
Reply With Quote
      03-19-2007, 12:18 PM   #3
Nitz99
Private First Class
 
Nitz99's Avatar
 
Drives: 2013 AW F30 335i Sport
Join Date: Sep 2006
Location: nyc

Posts: 137
iTrader: (1)

Send a message via AIM to Nitz99
type this exactly how it's displayed below into cell A3

=(((A2-5%)*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- cells-number tab-number"

you should get 519.97 if the value in cell A2 is 1000.
Nitz99 is offline   United_States
0
Reply With Quote
      03-19-2007, 01:54 PM   #4
billmister
Major
 
billmister's Avatar
 
Drives: e92 335i
Join Date: Nov 2006
Location: NJ

Posts: 1,211
iTrader: (1)

Send a message via AIM to billmister
aGOT IT!!!!!!!!

Nikki and Nitz99 THANK YOU GREATLY!!!! i REALLY appriciate this. Thank you!
billmister is offline   United_States
0
Reply With Quote
      03-19-2007, 01:55 PM   #5
billmister
Major
 
billmister's Avatar
 
Drives: e92 335i
Join Date: Nov 2006
Location: NJ

Posts: 1,211
iTrader: (1)

Send a message via AIM to billmister
I followed what both of you have posted and tested it out and it worked! Thanks
billmister is offline   United_States
0
Reply With Quote
      03-20-2007, 06:30 PM   #6
billmister
Major
 
billmister's Avatar
 
Drives: e92 335i
Join Date: Nov 2006
Location: NJ

Posts: 1,211
iTrader: (1)

Send a message via AIM to billmister
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:

7000-5%(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.
billmister is offline   United_States
0
Reply With Quote
      03-20-2007, 06:40 PM   #7
ctgazer
Major General
 
ctgazer's Avatar
 
Drives: a dilapidated ride
Join Date: Feb 2006
Location: canada eh!

Posts: 7,952
iTrader: (10)

Garage List
2006 e90  [0.00]
Send a message via MSN to ctgazer
Quote:
Originally Posted by billmister View Post
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:

7000-5%(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.
first of all, 5% of 350 is 17.5 therefore 7000-5%(350)=$6982.50 not $6650.00

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%]
__________________
ctgazer is offline   Canada
0
Reply With Quote
      03-20-2007, 06:49 PM   #8
billmister
Major
 
billmister's Avatar
 
Drives: e92 335i
Join Date: Nov 2006
Location: NJ

Posts: 1,211
iTrader: (1)

Send a message via AIM to billmister
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:
7000-350 =$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.
billmister is offline   United_States
0
Reply With Quote
      03-20-2007, 06:50 PM   #9
billmister
Major
 
billmister's Avatar
 
Drives: e92 335i
Join Date: Nov 2006
Location: NJ

Posts: 1,211
iTrader: (1)

Send a message via AIM to billmister
sorry to bother but i really would like help on this topic
billmister is offline   United_States
0
Reply With Quote
      03-20-2007, 07:26 PM   #10
billmister
Major
 
billmister's Avatar
 
Drives: e92 335i
Join Date: Nov 2006
Location: NJ

Posts: 1,211
iTrader: (1)

Send a message via AIM to billmister
anyone?... BTW the cap letter were not used as raised voice.
billmister is offline   United_States
0
Reply With Quote
      03-20-2007, 08:12 PM   #11
billmister
Major
 
billmister's Avatar
 
Drives: e92 335i
Join Date: Nov 2006
Location: NJ

Posts: 1,211
iTrader: (1)

Send a message via AIM to billmister
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!
billmister is offline   United_States
0
Reply With Quote
      03-20-2007, 08:24 PM   #12
cobradac
First Lieutenant
 
cobradac's Avatar
 
Drives: '05 645Ci Coupe
Join Date: Oct 2005
Location: Titusville, FLA

Posts: 374
iTrader: (0)

Garage List
2005 645Ci  [0.00]
If it were me I'd do it like this =+((A2*0.95)*0.55)-30
cobradac is offline  
0
Reply With Quote
      03-20-2007, 09:32 PM   #13
billmister
Major
 
billmister's Avatar
 
Drives: e92 335i
Join Date: Nov 2006
Location: NJ

Posts: 1,211
iTrader: (1)

Send a message via AIM to billmister
Quote:
Originally Posted by cobradac View Post
If it were me I'd do it like this =+((A2*0.95)*0.55)-30
you what?..... I broke my FREAKEN brain to get it... I called my girlfriend and she goes...??? Just do _____*.95*.55-30.... 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!
billmister is offline   United_States
0
Reply With Quote
      03-20-2007, 10:29 PM   #14
Ninjaneer
Shadow Warrior
 
Ninjaneer's Avatar
 
Drives: '07 335i Sedan
Join Date: Aug 2006
Location: Florida

Posts: 2,097
iTrader: (0)

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!)
Ninjaneer is offline   United_States
0
Reply With Quote
Post Reply

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -5. The time now is 08:50 AM.




m3post
Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
1Addicts.com, BIMMERPOST.com, E90Post.com, F30Post.com, M3Post.com, ZPost.com, 5Post.com, 6Post.com, 7Post.com, XBimmers.com logo and trademark are properties of BIMMERPOST