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