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.
