Hello, I need help with the following:

Column:
A B C D E F G
Sales COS % GP OH and profit
$93,000.00 49.70% $46,779.00 $46,500.00 $279.00 $279.00 $279.00
(All in row 4)

Column E should only have a number it it if B4 is less than or equal to 50% AND B4 is greater than 40%. Return a blank if not in that range. (Summary: E4 should have a response if B4 is between 41% and 50% - if not in this range, should be blank)
Column F should only have a number it it if B4 is less than or equal to 40% AND B4 is greater than 30%. Return a blank if not in that range. (Summary: F4 should have a response if B4 is between 31% and 40% - if not in this range, should be blank)
Column G should only have a number it it if B4 is less than or equal to 30%. Return a blank if not in that range. (Summary: G4 should only have a response if B4 is between 0 and 30% - if not in this range, should be blank)

Also please note:
E4, F4, G4 all have the formulas =C4-D4.
C4 has the following formula: =A4-(A4*B4)

Any help with this would be greatly appreciated.
Sincerely,
Eileen S.