Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

im trying to add two if statements. its not working =IF(Q7="<3,0,Q7,IF(q7=">100,100,Q7)
Solved by V. L. in 11 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 05/10/2018 - 11:56
Hi…Welcome to Got It Pro. I see that your question is about fixing formulas.
Excelchat Expert 05/10/2018 - 11:57
I can help you with that problem.
Excelchat Expert 05/10/2018 - 11:57
Before we get started, this is a quick reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows.
User 05/10/2018 - 11:57
i just copied the sheet
[Uploaded an Excel file]
Excelchat Expert 05/10/2018 - 11:57
Thanks for sharing the file.
Excelchat Expert 05/10/2018 - 11:58
Could you please tell me the logic you are trying to apply through this formula?
Excelchat Expert 05/10/2018 - 11:59
And just to confirm, the formula that you are referring is in column N, is that right?
User 05/10/2018 - 11:59
im trying to bring back 0 if the qty in q3 is less than 3 if its more than 100 then bring back 100 or the actual quantity
User 05/10/2018 - 11:59
yes that is correcy
User 05/10/2018 - 12:00
sorry typos keyboard is broken
Excelchat Expert 05/10/2018 - 12:00
No problem :) I can understand
Excelchat Expert 05/10/2018 - 12:01
So <3 should be 0
Excelchat Expert 05/10/2018 - 12:01
>100 should be 100
User 05/10/2018 - 12:01
yes
Excelchat Expert 05/10/2018 - 12:01
between 3 & 100, actual quantity
User 05/10/2018 - 12:01
yes...
Excelchat Expert 05/10/2018 - 12:01
Is that correct?
User 05/10/2018 - 12:01
correct
Excelchat Expert 05/10/2018 - 12:01
Perfect, let me rectify your formula.
Excelchat Expert 05/10/2018 - 12:03
Do you need this formula only till row 42?
User 05/10/2018 - 12:04
no- thru end of sheet
Excelchat Expert 05/10/2018 - 12:04
The rectified formula to be placed in N3 =IF(Q3<3,0,IF(Q3>100,100,Q3))
Excelchat Expert 05/10/2018 - 12:04
This same formula can be copied all the way down.
User 05/10/2018 - 12:05
ahhh i had way to many arguemnts going on
User 05/10/2018 - 12:05
thiswas easy... thank you
Excelchat Expert 05/10/2018 - 12:05
[Uploaded an Excel file]
Excelchat Expert 05/10/2018 - 12:06
I have uploaded the file with the rectified formula.
User 05/10/2018 - 12:06
thank yiu
Excelchat Expert 05/10/2018 - 12:06
You were almost there, just some syntax issue :)
Excelchat Expert 05/10/2018 - 12:06
Is there anything else I can help you with this query?
User 05/10/2018 - 12:06
no this is perfect
Excelchat Expert 05/10/2018 - 12:06
Please feel free to leave any comments or feedback.
User 05/10/2018 - 12:07
i will
Excelchat Expert 05/10/2018 - 12:07
Thanks for your time. Please do come back for any new question. You can now end this session. 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.

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.