Question description:
This user has given permission to use the problem statement for this
blog.
A2=50
A3=46
A4=39
=IF(A2>=48,100)
=IF(AND(A3<=47,A3>=41),120)
=IF(A4<=40,A4*3)
Individually this logic formula works with the desired value result. When I nested the IF's the only the first logic statement gave me a value result the other logic statements gave me a "False". Here is the nested formula I created.
=IF(A2<=40,A2*3,IF(AND(A2<=47,A2>=41,120),IF(A2>=48,100)))
Solved by C. C. in 11 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
09/04/2018 - 10:17
hello! how are you?
User
09/04/2018 - 10:17
Well, Thank you
Excelchat Expert
09/04/2018 - 10:18
can you please walk me through your problem? could you also paste the data to the document to the right so we can try to work on it real-time?
Excelchat Expert
09/04/2018 - 10:20
are you still there? i tried to copy the formula and data you provided on your description
User
09/04/2018 - 10:21
I have 3 scenarios that I'm trying to write a nested formula. However, I'm only getting a value for my first logic statement and "FALSE" on my other two nested IF statments
Excelchat Expert
09/04/2018 - 10:21
hi i think i figured it out
Excelchat Expert
09/04/2018 - 10:21
can you please check column C?
User
09/04/2018 - 10:23
Awesome!
Excelchat Expert
09/04/2018 - 10:24
would you like me to explain further?
Excelchat Expert
09/04/2018 - 10:24
in this formula=IF(A2<=40,A2*3,IF(AND(A2<=47,A2>=41,120),IF(A2>=48,100))) in this formula
User
09/04/2018 - 10:24
Yes, what did I do wrong?
Excelchat Expert
09/04/2018 - 10:25
you missed to close the AND() statement up until A2>41
Excelchat Expert
09/04/2018 - 10:25
so it should be....A2>=41),120,IF(...))))
Excelchat Expert
09/04/2018 - 10:25
that's all
Excelchat Expert
09/04/2018 - 10:25
:)
User
09/04/2018 - 10:26
Thank you for your help
Excelchat Expert
09/04/2018 - 10:26
you are most welcome. is it okay if i mark this problem "ANSWERED"?
User
09/04/2018 - 10:26
Yes
Excelchat Expert
09/04/2018 - 10:26
you may end the session as well, if you don't have any clarifications
Excelchat Expert
09/04/2018 - 10:26
Of course, your feedback and rating is highly appreciated too! :)
Excelchat Expert
09/04/2018 - 10:27
Thank you and have a good day
User
09/04/2018 - 10:27
You too
Excelchat Expert
09/04/2018 - 10:27
kindly end the session please?
Excelchat Expert
09/04/2018 - 10:27
thanks
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.