Excel - IF Function Problem - Expert Solution

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
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
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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.