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.