HopefulBride Posted May 24, 2011 Share Posted May 24, 2011 He showed that Vlookup function who's boss... Link to comment Share on other sites More sharing options...
MIKolbe Posted May 24, 2011 Share Posted May 24, 2011 indeed I did. Link to comment Share on other sites More sharing options...
tnavarro61 Posted May 24, 2011 Share Posted May 24, 2011 Link to comment Share on other sites More sharing options...
MIKolbe Posted May 24, 2011 Share Posted May 24, 2011 =VLOOKUP(C1,$A$4:$C$79,2,0) Link to comment Share on other sites More sharing options...
MIKolbe Posted May 24, 2011 Share Posted May 24, 2011 =IF(C32=0,0,(C32+0.65)/0.6) Link to comment Share on other sites More sharing options...
MIKolbe Posted May 24, 2011 Share Posted May 24, 2011 =VLOOKUP(B7,Sheet1!$A$1:$X$743,11,0) Link to comment Share on other sites More sharing options...
MIKolbe Posted May 24, 2011 Share Posted May 24, 2011 =IF(B9>$F$1*1.2,"Get Custom Quote",IF(B9>$F$1,$F$2,IF(B9>=$E$1,$E$2,IF(B9>=$D$1,$D$2,IF(B9>=$C$1,$C$2,IF(B9>=$B$1,$B$2,IF(B9>=$A$1,$A$2,"Use Catalog Pricing"))))))) Link to comment Share on other sites More sharing options...
MIKolbe Posted May 24, 2011 Share Posted May 24, 2011 =IF(W181<0.029,IF(F181>E181,F181,E181),IF(W181=1,IF(F181>E181,F181,E181),(E181+F181)/2)) Link to comment Share on other sites More sharing options...
MIKolbe Posted May 24, 2011 Share Posted May 24, 2011 =IF(B182="ceramic",0.6,IF(B182="Glass",IF(G182<=0.5,0.42,0.6),IF(B182="Plastics",0.85,IF(B182="Stainless Steel",1,IF(B182="Stainless Steel and Other",1,IF(B182="aluminum",0.8,0)))))) Link to comment Share on other sites More sharing options...
Groo the Wanderer Posted May 24, 2011 Share Posted May 24, 2011 =IF(B182="boogy",0.6,IF(B182=" woogie",IF(G182<=0.5,0.42,0.6),IF(B182=" bugle",0.85,IF(B182="boy",1,IF(B182="from",1,IF(B182="Company B" ,0.8,0)))))) Link to comment Share on other sites More sharing options...
MIKolbe Posted May 24, 2011 Share Posted May 24, 2011 that formula most likely would not work because you have a space before Company B. " Company B" will most likely result in #N/A, whereas "Company B", would result in 0.80. BOO YA!!!!! Link to comment Share on other sites More sharing options...
dominicansoul Posted May 25, 2011 Share Posted May 25, 2011 ...a chump! Link to comment Share on other sites More sharing options...
MIKolbe Posted May 25, 2011 Share Posted May 25, 2011 DS, dont anger me Link to comment Share on other sites More sharing options...
Lil'Monster Posted May 25, 2011 Share Posted May 25, 2011 mlkolbe is a...a.....a....a...a CHUMP just kidding dude u know we love ya ur one handsome dude! Link to comment Share on other sites More sharing options...
Ed Normile Posted May 25, 2011 Share Posted May 25, 2011 Mikolbe has been elevated to chump! Man this guy is really moving on up. I knew I liked him for a reason. ed Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now