Nested IF function is not working

[sprinklerman]

I am having problems with this IF function, It is for pricing with price breaks for areas over 20000, and a bigger break for areas over 30000. Any help would be greatly appreciated.

The background! B9, C10, D10, and E10 are on another sheet in the workbook.

=IF(D2<4167,background!B9,IF(4168<d2>19999,(background!C10),IF(20000<d2>29999,(background!D10),IF(D2>30000,(background!E10)))))</d2></d2>

 

[Special-K99]

This doesnt quite make sense.

You're testing D2 for various limits and wanting to return certain cells fromt he looks of things.

What are those limits and corresponding cells?

 

[elmer007]

How about: =IF(D2<4167,background!B9,IF(D2<20000,background!C10,IF(D2<30000,background!D10,background!E10)))

 

[Jonmo1]

Welcome to the board.
Looks like parts of your formula got cut off.
Forum software tends to treat < and > symbols as HTML code, and stuff gets cut off.
When posting formulas, put spaces around those symbols.

Anyway, I'd guess you were trying something like

=IF(D2<4167,background!B9,IF(4168 < D2 < 19999,(background!C10),IF(20000 < D2 < 29999,(background!D10),IF(D2>30000,(background!E10)))))

That's not valid syntax
You'd have to do
=AND(D2>=4168,D2<20000)

However, you don't need to test for the >=4168, because the formula already did that with the first IF, IF(D2<4167

Try like this
=IF(D2<4167,background!B9,IF(D2<19999,background!C10,IF(D2<29999,background!D10,background!E10)))

 

[sprinklerman]

Thank you for the help

 

[Jonmo1]

You're welcome.