Help with Logical Formula

[Guest]

This is part of a formula I am trying to make work.
Any help would be greatly appreciated.

$B$102=53000, $B$103=7000, and $B$104=6000, $D$96=12

What I would like to see happen is for B24 to return the number 12 if the
number I enter into B$7 is greater than $B$102, or $B$103, or $B$104. The
rest of the formula works fine.

B24 = the formula;
=IF($B$7>$B$102,$D$96,IF(AND(B$17<=$B$105,$F$5>0,B$20<=6),($F$5*$D$106)+$D$97,IF(AND(B$17>$B$105,B$20<=6),$D$98+(B$17*$B$106*$F$5),IF(B$20>6,($F$5*$D$99)+$D$97+(B$17*$B$106*$F$5),$D$100))))

Thanks in advance.

 

[Guest]

=if(b7>max(b102:b104),12,otherwise)

 

[Guest]

Thank you "bj", but your formula is only returning 12 when the number I enter
into $B$7 is 53001 or higher. We need it to return 12 if I enter 6001, or to
return 12 if I enter 7001, or to return 12 if I enter 53001 into $B$7

We need it to recognize any of the number series, not just the largest one.

These numbers represent 3--Work Order number series we are using.

I am sorry if I was not clear enough.

 

[Pete_UK]

So really, anything larger than 6000 should cause 12 to be returned.
Try it this way round:

=if(b7>min(b102:b104),12,otherwise)

Hope this helps.

Pete

 

[Guest]

Thank you also Peter_UK. That is not it either.

Yes, I do want the cell B24 to return 12 if I enter 6001 in B7, But, I want
it to enter a different number if B7 is less than 6000

Yes, I do want the cell B24 to return 12 if I enter 7001 in B7, But, I want
it to enter a different number if B7 is less tha 7000

Yes, I do want the cell B24 to return 12 if I enter 53001 in B7, But, I want
it to enter a different number if B7 is less tha 53000

B24 = the full formula;
=IF($B$7>$B$102,$D$96,IF(AND(B$17<=$B$105,$F$5>0,B$20<=6),($F$5*$D$106)+$D$-97,IF(AND(B$17>$B$105,B$20<=6),$D$98+(B$17*$B$106*$F$5),IF(B$20>6,($F$5*$D$-99)+$D$97+(B$17*$B$106*$F$5),$D$100))))