View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
talltom talltom is offline
external usenet poster
 
Posts: 22
Default 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))))