**Question description:**

*This user has given permission to use the problem statement for this blog.*

I key in 999 and expect the following formula to return a set value but instead it returns the zero.... the formula works on numbers below 499.... =IF(B35<99,I21,IF(AND(B35>=100,B35<=249),I22,IF(AND(B35>=250,B35<=499),I23,IF(AND(B35>=500,B35<=999,I24),IF(B35>=1000,I25,0)))))

Solved by I. H. in 17 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
11/06/2018 - 07:36

Hi…Welcome to Got It Pro

User
11/06/2018 - 07:36

HI

Excelchat Expert
11/06/2018 - 07:37

So you are saying that your present formula is not working beyond 499, is that right?

User
11/06/2018 - 07:37

Correct

Excelchat Expert
11/06/2018 - 07:37

ok...let me illustrate with some data in this preview sheet

User
11/06/2018 - 07:37

ok

Excelchat Expert
11/06/2018 - 07:38

can you put in the values in column I as per your formula?

User
11/06/2018 - 07:41

Sorry let me replicate what I have is that ok....?

Excelchat Expert
11/06/2018 - 07:41

sure

User
11/06/2018 - 07:43

ok...there you go...

Excelchat Expert
11/06/2018 - 07:43

ok got it

Excelchat Expert
11/06/2018 - 07:43

Let me amend the formula

User
11/06/2018 - 07:43

Ah i can see it myself now....

User
11/06/2018 - 07:43

Cell doesn't show 499

User
11/06/2018 - 07:44

Ah no...that doesn't work...

User
11/06/2018 - 07:45

Yes plese...

Excelchat Expert
11/06/2018 - 07:46

Give me a moment

Excelchat Expert
11/06/2018 - 07:47

Is that ok now?

User
11/06/2018 - 07:48

Yep...what was it....?

Excelchat Expert
11/06/2018 - 07:48

It was the brackets

Excelchat Expert
11/06/2018 - 07:49

The last IF argument had the bracket at the wrong place.

Excelchat Expert
11/06/2018 - 07:49

Is there anything else I can help you with this query?

User
11/06/2018 - 07:49

Ah yes can see it...thank you...

Excelchat Expert
11/06/2018 - 07:50

Please do give me a good feedback for my service.

Excelchat Expert
11/06/2018 - 07:50

Thanks for your time. Please do come back for any new question. Have a great day ahead!

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*