ChevyBoy95 Posted September 11, 2012 Report Share Posted September 11, 2012 doing a project where you enter day and it runs it though formulas to test distance, velocity, height, etc. well there are restrictions for if it is ok to launch the projectile. restrictions: 1. cant be farther than 6500m 2. test duration longer than 10seconds 3. less than 150m/s now what i need the formula to do is display: ok to launch when shorter than 6500, but fail - range exceeded when over 6500 ok to launch when longer than 10s, but fail - time when under 10 ok to launch when slower than 150m/s, but fail - speed when over 150 this will all be 1 string and use an IF function. it is the only think i havent done and is irritating. someone with excel knowledge/ EE's step in and help please. Best Score to Date : 160.5 dB Outlaw (47Hz)[4 XM 15's & 2 Taramps Bass 12k's] BL : http://www.stevemeadedesigns.com/board/topic/147800-chevyboy95s-4-15s-7krms-wall-1533-db-on-half-power/YouTube: http://www.youtube.com/hitemwiththeflex/ Link to comment Share on other sites More sharing options...
ChevyBoy95 Posted September 12, 2012 Author Report Share Posted September 12, 2012 anyone? Best Score to Date : 160.5 dB Outlaw (47Hz)[4 XM 15's & 2 Taramps Bass 12k's] BL : http://www.stevemeadedesigns.com/board/topic/147800-chevyboy95s-4-15s-7krms-wall-1533-db-on-half-power/YouTube: http://www.youtube.com/hitemwiththeflex/ Link to comment Share on other sites More sharing options...
Maxim Posted September 12, 2012 Report Share Posted September 12, 2012 =IF([RANGE]>6500,"FAIL - RANGE",IF([TIME]<10,"FAIL - TIME",IF([sPEED]>150,"FAIL - SPEED","PASS"))) Replace [DISTANCE] [TIME] [sPEED] with the cell values that represent them (I used A1 B1 C1 to test) You can replace the FAIL messages with whatever you want. Just be sure to leave them in quotes. This formula fails if: a.) distance is greater than 6500 (6500.1 fails, 6500 passes) b.) time is less than than 10 (9.999999999 fails, 10 passes) c.) speed is greater than 150 (150.1 fails, 150 passes) wtf is lolcats? I'd def get a fat hooker if i had to resort to that kinda thing. I feel like they'd be grateful and work harder. Also its more bang for my buck, more real estate for my dollar if you catch my drift. its like the Costco of streetwalkers. I was hoping for 150 . I was hoping she would let me put it in her butt Link to comment Share on other sites More sharing options...
ChevyBoy95 Posted September 12, 2012 Author Report Share Posted September 12, 2012 thank god maxim, ill go test it out. put a few hours into the spread sheet and this is all i had to do. Best Score to Date : 160.5 dB Outlaw (47Hz)[4 XM 15's & 2 Taramps Bass 12k's] BL : http://www.stevemeadedesigns.com/board/topic/147800-chevyboy95s-4-15s-7krms-wall-1533-db-on-half-power/YouTube: http://www.youtube.com/hitemwiththeflex/ Link to comment Share on other sites More sharing options...
412 CVX Posted September 12, 2012 Report Share Posted September 12, 2012 God damn! I need to learn how to use this stuff. Just say no to Ground Pounder Customs. My temp system build log More box buildssome cars do over 170db with one sub, so clearly my two 12"s can do that in my car, with my knowledge too! look out bitches! I'm with captain stupid. Link to comment Share on other sites More sharing options...
MrSkippyJ Posted September 12, 2012 Report Share Posted September 12, 2012 God damn! I need to learn how to use this stuff. IF statements are pretty basic in Excel. You can do some pretty crazy stuff with Excel F150: Stock 2019 Harley Road Glide: Amp: TM400Xad - 4 channel 400 watt Processor: DSR1 Fairing (Front) 6.5s -MMats PA601cx Lid (Rear) 6x9s - TMS69 Link to comment Share on other sites More sharing options...
ChevyBoy95 Posted September 12, 2012 Author Report Share Posted September 12, 2012 yea i know, had something VERY VERY similar, just too much, basically a over complicated version of what maxim wrote. there was harder stuff to do on the spreadsheet but it just went south when i got to this part. Best Score to Date : 160.5 dB Outlaw (47Hz)[4 XM 15's & 2 Taramps Bass 12k's] BL : http://www.stevemeadedesigns.com/board/topic/147800-chevyboy95s-4-15s-7krms-wall-1533-db-on-half-power/YouTube: http://www.youtube.com/hitemwiththeflex/ Link to comment Share on other sites More sharing options...
MrSkippyJ Posted September 12, 2012 Report Share Posted September 12, 2012 my bad man, I didn't mean to aim that at you! I was letting 412 know that if he thinks that is crazy, there are far crazier things to be done with Excel F150: Stock 2019 Harley Road Glide: Amp: TM400Xad - 4 channel 400 watt Processor: DSR1 Fairing (Front) 6.5s -MMats PA601cx Lid (Rear) 6x9s - TMS69 Link to comment Share on other sites More sharing options...
ChevyBoy95 Posted September 12, 2012 Author Report Share Posted September 12, 2012 i know, i saw after i posted and didnt feel like correcting it. but im a noob at it too, havent used excel since freshman yr at highschool. what we do in the class isnt difficult, it just applies physics and uses excel to carry out the problem solving, starting matlab in a week though. Best Score to Date : 160.5 dB Outlaw (47Hz)[4 XM 15's & 2 Taramps Bass 12k's] BL : http://www.stevemeadedesigns.com/board/topic/147800-chevyboy95s-4-15s-7krms-wall-1533-db-on-half-power/YouTube: http://www.youtube.com/hitemwiththeflex/ Link to comment Share on other sites More sharing options...
MrSkippyJ Posted September 12, 2012 Report Share Posted September 12, 2012 i used excel where i worked for a while. i only used it to merge parts prices from the companies database to what my little area did. I just entered our production hit enter and viola, it showed how much money we made that day. F150: Stock 2019 Harley Road Glide: Amp: TM400Xad - 4 channel 400 watt Processor: DSR1 Fairing (Front) 6.5s -MMats PA601cx Lid (Rear) 6x9s - TMS69 Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.