TSB67 Posted November 29, 2011 Report Share Posted November 29, 2011 =Dont((Trust),Mj,"She's a woman":WhichIs(< Men)) GOTO Kitchen Quote Link to comment Share on other sites More sharing options...
CoolWhip Posted November 29, 2011 Report Share Posted November 29, 2011 =Dont((Trust),Mj,"She's a woman":WhichIs(< Men)) GOTO Kitchen PURE AWESOME! Quote Link to comment Share on other sites More sharing options...
OsuMj Posted November 29, 2011 Report Share Posted November 29, 2011 You could do a range row and do the max of the min column, and the min of the max column, then if the first one exceeds the second one then you've got a problem anyway. Quote Link to comment Share on other sites More sharing options...
OsuMj Posted November 29, 2011 Report Share Posted November 29, 2011 (edited) i'm sorry i'm smarter than you jrmmmmm. I didn't realize i hurt your feelings so bad. Edited November 29, 2011 by OsuMj Quote Link to comment Share on other sites More sharing options...
chevysoldier Posted November 29, 2011 Author Report Share Posted November 29, 2011 You could do a range row and do the max of the min column, and the min of the max column, then if the first one exceeds the second one then you've got a problem anyway.Something like this? =IF(DMAX(B2:B7)<(DMIN(C2:C7),"stop") That doesn't work though. Quote Link to comment Share on other sites More sharing options...
OsuMj Posted November 29, 2011 Report Share Posted November 29, 2011 well, I was thinking you should do your "limits" row the other way. It won't be helpful to know the lower limit of your min column, right? Its more helpful to know the upper limit of your min column. so if you do MAX(B2:B6) and MIN(C2:C6), that will give you an operable range. Then, you can make one column, just to the right of that =IF(B7<C7, "operable range", "no operable range") Quote Link to comment Share on other sites More sharing options...
chevysoldier Posted November 29, 2011 Author Report Share Posted November 29, 2011 well, I was thinking you should do your "limits" row the other way. It won't be helpful to know the lower limit of your min column, right? Its more helpful to know the upper limit of your min column. so if you do MAX(B2:B6) and MIN(C2:C6), that will give you an operable range. Then, you can make one column, just to the right of that =IF(B7<C7, "operable range", "no operable range")ah ha! I see what you mean now. I'll try that Quote Link to comment Share on other sites More sharing options...
chevysoldier Posted November 29, 2011 Author Report Share Posted November 29, 2011 How do I make it ≤? 30 is not < than 30 and therefore returns as not operable even though it is still fine. Quote Link to comment Share on other sites More sharing options...
OsuMj Posted November 29, 2011 Report Share Posted November 29, 2011 I think <= Quote Link to comment Share on other sites More sharing options...
chevysoldier Posted November 29, 2011 Author Report Share Posted November 29, 2011 I think <=Bingo. I think it's now where I want it. lol. Thanks! Quote Link to comment Share on other sites More sharing options...
OsuMj Posted November 29, 2011 Report Share Posted November 29, 2011 np! Quote Link to comment Share on other sites More sharing options...
chevysoldier Posted November 29, 2011 Author Report Share Posted November 29, 2011 Got it to where I like it. http://www.youtube.com/watch?v=bmGhgKyAtg8 Quote Link to comment Share on other sites More sharing options...
jporter12 Posted November 29, 2011 Report Share Posted November 29, 2011 I went and checked out a bunch today. But I need to get sand, live plants and rocks first.That's probably about right, 50/50...I think most of the regulars at Jack's are a little bit above 50% correct, and if you go to Aquarium Adventures, they are a LOT better, not to mention the selection being HUGE! Quote Link to comment Share on other sites More sharing options...
OsuMj Posted November 29, 2011 Report Share Posted November 29, 2011 Got it to where I like it. Nice! Quote Link to comment Share on other sites More sharing options...
chevysoldier Posted November 30, 2011 Author Report Share Posted November 30, 2011 I think most of the regulars at Jack's are a little bit above 50% correct, and if you go to Aquarium Adventures, they are a LOT better, not to mention the selection being HUGE!You're probably correct but Jack's is where I bought by Tiger Barbs that were supposed to be peaceful. At AA I just told them what I wanted and didn't discuss it with them.Nice!Thank you. More than welcome to DL if you want. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.