Need Formula/condition if one cell is within a percentage range- Results in 3 cells

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.

Sorry I am new, how do I add an attachment to my post?

Here is the attachment.

Thank you.

Thank you. I tested it and just a couple of things;
i.e. If the result is between 41 & 50% in B7 - the result that should show in E7 should be the difference between =C7-D7 (not A7*B7)
Also the result should only show in one cell depending on the criteria of the percentage in B7: one result in E7 or F7 or G7

I have attached my test spreadsheet. Can this be tweaked?
Thanks,
Eileen

OMG!! That's perfect. Thank you so much and Happy New Year to you.

Oh my God!!! (just an expression)

thanks again