=if(b7max(b102:b104),12,otherwise)

"talltom" wrote:

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$50,B $20<=6),($F$5*$D$106)+$D$97,IF(AND(B$17$B$105,B$2 0<=6),$D$98+(B$17*$B$106*$F$5),IF(B$206,($F$5*$D$ 99)+$D$97+(B$17*$B$106*$F$5),$D$100))))

Thanks in advance.