Need help making a formula for Excel

[TSB67]

=Dont((Trust),Mj,"She's a woman":WhichIs(< Men)) GOTO Kitchen

[CoolWhip]

=Dont((Trust),Mj,"She's a woman":WhichIs(< Men)) GOTO Kitchen

PURE AWESOME!

[OsuMj]

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.

[OsuMj]

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

[chevysoldier]

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.

[OsuMj]

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")

[chevysoldier]

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

[chevysoldier]

How do I make it ≤? 30 is not < than 30 and therefore returns as not operable even though it is still fine.

[OsuMj]

I think <=

[chevysoldier]

I think <=

Bingo. I think it's now where I want it. lol. Thanks!

[OsuMj]

np!

[chevysoldier]

Got it to where I like it.

http://www.youtube.com/watch?v=bmGhgKyAtg8

[jporter12]

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!

[OsuMj]

Got it to where I like it.

Nice!

[chevysoldier]

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.