Help with a formula:co-worker designed

Hi All, maybe you can help. I have a spreadsheet a co-worker designed and asked my help in. It helps calculate net pay, and had a question regarding a formula.

In cell D8, is my gross pay, which is a calculation from another worksheet.
There are four different calculations (depending on the gross pay) to determine net pay.

The four formulas being used are:
=IF($D$8>0,IF($D$8>308,IF($D$8<869,$D$8,"")))

=IF($D$8>0,IF($D$8>869,IF($D$8<2546,$D$8,"")))

=IF($D$8>0,IF($D$8>2546,IF($D$8<4644,$D$8,"")))

=IF($D$8>0,IF($D$8>4644,IF($D$8<7292,$D$8,"")))

The bottom two formulas are returning a FALSE value. I attached a screenshot of the spreadsheet.
Is there a better way to write these formulas in that don't return a value of FALSE?

Thanx...LT

Here's the screenshot.

Originally Posted by NBVC

All formulas can be replaced with formulas containing AND() function...

e.g.

=IF(AND($D$8>2546,$D$8<4644),$D$8,"")

don't think you need the $D$8>0 qualifier if you are looking in a range.

Thanx....worked great.

LT