Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Logical Formula
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Logical Formula
=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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Logical Formula
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. "bj" wrote: =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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Logical Formula
So really, anything larger than 6000 should cause 12 to be returned.
Try it this way round: =if(b7min(b102:b104),12,otherwise) Hope this helps. Pete On Nov 5, 7:24 pm, talltom wrote: 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. "bj" wrote: =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$ 20<=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.- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Logical Formula
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$50,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$206,($F$5*$D$-99)+$D$97+(B$17*$B$106*$F$5),$D$100)))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple logical formula | Excel Worksheet Functions | |||
Need help about logical formula | Excel Worksheet Functions | |||
Excel Logical Formula | Excel Discussion (Misc queries) | |||
Logical formula with dates | Excel Worksheet Functions | |||
Logical Text Formula | Excel Worksheet Functions |